Hello,

I want to count how many columns a table has, and to display their name list.

Example:
Table name is tbl_mytable,
Assume that tbl_mytable has 5 columns named mycol1,...,mycol5.

What is the SQL command to count and to show the list?

output should be:

There are 5 columns tbl_mytable has

Column Names
mycol1
mycol2
mycol3
mycol4
mycol5


The command:
SELECT COL_NAME(OBJECT_ID('tbl_mytable'), 1)
returns first column name: mycol1

If I can count the columns, it is easy to get the list with like
for x = 1 to columncount

SELECT COL_NAME(OBJECT_ID('tbl_mytable'), columncount)

next

Regards,
Sbaser