Common Name Restrictions | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Common Name Restrictions

On tables and columns, what are common name restrictions? Jonathan Casuncad – 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:<br /><br />select [select] from [from] where [where]=’do not do this'<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br /><hr noshade size="1">SqlSpec – a fast, cheap, and comprehensive data dictionary generator <br />for SQL Server 2000 and 2005 and Analysis Server 2005 – <br />
Here is a list of keywords, which you should avoid when naming objects. Roji. P. Thomas

Also refer
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=’:)‘ />]. <br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by makapangyarihan</i><br /><br />On tables and columns, what are common name restrictions?<br /><br />Jonathan Casuncad<br /<a target="_blank" href=></a> – SQL Server Performance Reporting Tool. Free 30-day trial download<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>