Aug 14, 2002 #1 eloise Programmer Jan 31, 2002 20 0 0 US Can you count the amount of columns in a table in SQL Server? If so, please tell me the syntax. Thank you in advance
Can you count the amount of columns in a table in SQL Server? If so, please tell me the syntax. Thank you in advance
Aug 14, 2002 #2 rt63 IS-IT--Management Aug 20, 2001 255 0 0 IN select count(*) from syscolumns where object_name(id) = 'UrTable' RT Upvote 0 Downvote