SQL Server Performance Forum – Threads Archive

Common Name Restrictions

On tables and columns, what are common name restrictions? Jonathan Casuncad
http://www.sqltraceanalyzer.com – SQL Server Performance Reporting Tool. Free 30-day trial download

there are no real restrictions if you enclose the name in square brackets. however it’s very confusing to use reserved words in object names. code like the below should be avoided: select [select] from [from] where [where]=’do not do this' [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] <hr noshade size="1">SqlSpec – a fast, cheap, and comprehensive data dictionary generator for SQL Server 2000 and 2005 and Analysis Server 2005 – www.elsasoft.org

Here is a list of keywords, which you should avoid when naming objects.
http://sqlserver2000.databases.aspfaq.com/what-are-reserved-access-odbc-and-sql-server-keywords.html Roji. P. Thomas
http://toponewithties.blogspot.com

Also refer
http://vyaskn.tripod.com/object_naming.htm
Madhivanan Failing to plan is Planning to fail

I would like to know what kind of naming convention you would like to adopt [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]. <blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by makapangyarihan On tables and columns, what are common name restrictions? Jonathan Casuncad http://www.sqltraceanalyzer.com</a> – SQL Server Performance Reporting Tool. Free 30-day trial download <hr height="1" noshade id="quote"></blockquote id="quote"> <hr noshade size="1">Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing.</center>

]]>