May 22, 2002 at 9:13 am
Having built a table using SQL Query Analyzer called TEST_DB. With one of the columns called POSITION. The issue is when I look at the table through Enterprise Manager > Design Table, the column in question appear on the table with [] i.e. [POSITION]. Though when I look at the same table data the [] no longer appear on the column. Is there anything I should be aware of with this table or column?
Gary Friel
Gary Friel
May 22, 2002 at 11:21 am
It's a reserved word (ODBC). EM adds the brackets for you I think.
Andy
May 22, 2002 at 11:37 am
Yes EM recognizes reserved words for the version of EM is installed from and automatically generates the [] to qualify. They do not actually exist if you look at in syscolumns table. Like this
select [name] from syscolumns where [id] = object_id('tablenamehere')
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply