[dba-VB] Reserved words

I have used brackets or/and a prefix to get around this issue.  I deal with
stocks and to have a table named ASK is not possible, but tblASK or [ASK]
works.  I prefer the tbl prefix since it is easy to prepend it to the
proposed name.

On Nov 30, 2007 1:43 PM, jwcolby <jwcolby at colbyconsulting.com> wrote:

> Does anyone know if the reserved words in SQL Server (can't be used in
> table
> names etc) are in a table anywhere (in sql server)?  I have code that
> builds
> tables and it really needs to check the proposed table name to make sure
> that the name isn't a reserved word, and that it does not have special
> characters.  I have had TWO times now where I was hunting down errors
> caused
> by issues with what is valid in a table name.
>
> I could build a table of reserved words but if any new ones are added my
> list would be short.
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>


-- 
Mark Rider
http://commonsensesecurity.info

Try to learn something about everything and everything about something.
 - Thomas H. Huxley