07-20-2023, 12:04 PM
I recommend checking out Microsoft's SQL Server sample databases:
<https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks>
The AdventureWorks sample uses a very clear and consistent naming convention that uses schema names for the organization of database objects.
1. Singular names for tables
2. Singular names for columns
3. Schema name for tables prefix (E.g.: SchemeName.TableName)
4. Pascal casing (a.k.a. upper camel case)
<https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks>
The AdventureWorks sample uses a very clear and consistent naming convention that uses schema names for the organization of database objects.
1. Singular names for tables
2. Singular names for columns
3. Schema name for tables prefix (E.g.: SchemeName.TableName)
4. Pascal casing (a.k.a. upper camel case)