T-SQL QUESTION - SQL SERVER 2000 - SELECT ROWGUIDCOL FROM NEWTABLE - DOES NOT WORK - WHY?

Supposedly the following Select is valid assuming you have a valid field property built in the table:

SELECT ROWGUIDCOL FROM NEWTABLE

Mine does not.  Do you know why?

Further, are there other syntax to point to actual columns with a generic call?
michaelrobertfrenchAsked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
SELECT ColumnProperty(OBJECT_ID('urtable'), 'ColumnName', 'IsRowGuidCol')
0
 
ptjcbCommented:
ROWGUIDCOL is a property of a column, not (usually) a column name. Your SELECT statement would work if  ROWGUIDCOL was the name of the column. That's why aneeshattingal's query would work.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.