select count(*)as NOC from SYSCOLUMNS where id=(select id from SYSOBJECTS where name='tablename')
sql query to get column count of table-query to get number of columns in table
select count(*)as NOC from SYSCOLUMNS where id=(select id from SYSOBJECTS where name='tablename')
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment