Column Name

[murugavelmsc]

Hi,

in sql server, how to find out no. of column names in a database

eg.

comp database

in emp table
eno

in department table
eno

it return 2

Thanks,
Murugavel

[deepuv04]

Hi,

in sql server, how to find out no. of column names in a database

eg.

comp database

in emp table
eno

in department table
eno

it return 2

Thanks,
Murugavel

Hi,


SELECT count(*) FROM INFORMATION_SCH EMA.COLUMNS

[ck9663]

For number of columns for a specific table, try:

select count(*) from syscolumns
where id in (select id from sysobjects where name = 'YourtableName')

-- CK