Naming Standards for SQL objects

[Dick Butler]

I was wondering if there are generally accpeted naming standards for SQL Server ojbects (tables, store procedeures, triggers, views etc.) that might be available somewhere on the WEB. I was also wondering if most DBA`s prefix the object names like "sp_" or suffix the object like "Customer_T"? Any opinions?

[Harlan Black]

On 9/2/98 5:29:46 AM, Dick Butler wrote:
> I was wondering if there are generally accpeted naming standards for SQL
> Server ojbects (tables, store procedeures, triggers, views etc.) that might
> be available somewhere on the WEB. I was also wondering if most DBA`s
> prefix the object names like "sp_" or suffix the object like "Customer_T"?
> Any opinions?

For stored procedures that affect only one table, prefix the procedure name
with an acronym for the table. This will bunch them together and is helpful
when you change the table structure and you need to select them for
recompilation.

For table names we use Microsoft`s suggested naming conventions for MS Access.