I did not specify a version of SQL Server because thus far, this particular oddity has happened on both SQL Server 2000 in Enterprise Manager and SQL Server 2008 in Management Studio.
When I write a create table script all of the reserved words that belong to SQL Server show up in Blue. Thats been a standard (words like datetime, char, nvarchar, int, primary key etc etc)
My question is why does the word 'status' show up in blue? It is not on any reserved word list that I can find. When I run the script, the table is created with no issue.
Nevertheless, I am concerned that I'm actually using a reserved word that will, at some point down the road, bite in the behind.
Has this happened to anyone else?
(I tried copying the script into this post, but the coloring did stay so I've attached exactly what it looks like in a word 2003 document)
Reply With Quote