SELECT COUNT(COLUMN_NAME) FROM ALL_TAB_COLS WHERE TABLE

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

Question Posted / laxmi reddy

Answer Posted / laxmi reddy

SELECT COUNT(COLUMN_NAME) FROM ALL_TAB_COLS WHERE
TABLE_NAME=<'TABLE_NAME'>;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How can you check the level of fragmentation on a table?

1045

Determine when an index is appropriate?

1078

What is the difference between DATETIME2 and DATETIME?

1081

How will you go about resolving deadlocks?

971

Differentiate between sql temp table vs table variable?

885

What is database isolation in sql server? : sql server database administration

1109

Explain the use of keyword with encryption. Create a store procedure with encryption?

961

How can we migrate from SQL server to SQL Azure?

113

What is dml command?

973

How to use union to merge outputs from two queries together in ms sql server?

1069

What is the tcp/ip port on which sql server runs?

1161

Distinguish between commit and rollback?

964

How to generate create procedure script on an existing stored procedure?

1011

How to drop an existing schema in ms sql server?

1103

How to bind a view to the schema of the underlying tables?

1001