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

Can we create clustered index on composite key?

979

Do you know what are pages and extents? : SQL Server Architecture

941

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

914

Explain about unique identifier data type in sql server?

857

What is stretch database in sql server?

1026

Explain about analysis services?

980

What is importing utility?

933

Explain the cursor lock types?

982

Write an SQL query to obtain the 2nd highest salary.

1019

What is it unwise to create wide clustered index keys?

953

What is the full form of ddl?

864

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

995

Can select statements be used on views in ms sql server?

1002

Is it ok to shrink transaction log?

936

How to find which stored procedure is currently running in sql server?

925