Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dbar
Starting Member
12 Posts |
 Posted - 2008-11-07 : 08:24:46
|
| I have been asked to use "Microsoft Naming Conventions" in a new application. SQL Server (2005-2008) will most likely be the database platform. I have not been able to locate "official" Microsoft naming standards for SQL Server database objects (tables, columns, views, stored procedures, etc.)Can anyone steer me in the right direction? Thanks. |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2008-11-07 : 08:50:33
|
| I am not sure that there is a Micorsoft Naming convention document that you can get....I just stick to the rule and make sure that they are consistant i.e. naming or table column and all opject I use a capital letter for the start of each word eg. TestTable or CustomerID, FirstName That kind of thing is a good start |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-11-11 : 15:18:17
|
| Avoid using reserved words. Stored procedures should not begin with "sp_" (we use "usp_" which statnds for user stored procedure). Avoid spaces in the names. As Neil stated, I don't believe there is a standard naming convention, just sort of a series of "best practices" of what NOT to do.Terry |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-11-12 : 10:56:37
|
| Prefix all tables and columns with the letters "Micro".If it is not practically useful, then it is practically useless. |
|
|
|
|
|
|
Microsoft Naming Conventions