select count(column_Name) from information_schema.columns where table

how to find number of columns in a table in sql server 2000
and 2005 also

Question Posted / saravanan p

Answer Posted / saravanan p

select count(column_Name) from information_schema.columns
where table_name='tableName'

Is This Answer Correct ?

8 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to get nth highest salary from employee table.

1163

What is field with example?

923

Is it possible for a stored procedure to call itself or recursive stored procedure?

952

How do I make a resultset scrollable?

958

Explain the types of indexes.

1216

What are xml indexes?

952

What different steps will a sql server developer take to secure sql server?

993

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1086

Can the query output be sorted by multiple columns in ms sql server?

980

What area unit the various kinds of info compression introduced in sql server 2008?

1088

Explain how many types of relationship?

1027

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

995

What is the difference between varchar and nvarchar datatypes?

1086

Can a function call a stored procedure in sql server?

960

why would you call update statistics? : Sql server database administration

1086