Identifying the ID column

[SteveMac32]

Hi all,
I have created a grid and am loading it from a recordset, these values can be changed by the user and then written back to the database (SQL 7), because of this I will want to suppress the ID column is there anyway I can identify this in the stored procedure that loads the recordset an so not return it.

Many thanks

Steve

 

[vanoordt]

this should do:

select name
from syscolumns
where id = object_id('<table>')
and colstat & 1 = 1

taken from the sp_help procedure regards,
Paul

 

[SteveMac32]

Thanks a lot Paul really appreciate that, it works a treat, how do you mean when you say ‘taken from the sp_help procedure’

 

[vanoordt]

The sp_help procedure, among many other things, gives the id column. The T-SQL code of sp_help can be seen either through the Enterprise Manager, or in the Query Analyzer with the command:

exec sp_helptext sp_help

in the Master database.

regards,
Paul