Anyone have a good link or document on naming standards and conventions for
What I use are self explanitory names. for instance if i created an
accounting DB. My naming conventions are
Accounting_Data for data device
Accounting_Log for log device
Accounting data base name
sales table name
pk_'column name' primary key
fk_'column name' foriegn key
you get the idea!
if you need an example check out the pubs database that is created with SQL
Server. I hope this is what you were refering to?
Are there any SQL Server specific documents for standards on naming of file
groups, setup of directory structures, table names, index names etc...?
Something similar to Oracle OFA.