Tuesday, March 20, 2012

number of columns in table

How can I determine the number of columns in a table?join syscolumns and sysobjects tables to count the number of columns.|||or use INFROMATION_SCHEMA.COLUMNS|||select * from syscolumns where id = object_id('<table name>')

No comments:

Post a Comment