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

Give main differences between "Truncate" and "Delete".

1087

how to define testing of network layers? : Sql server database administration

961

How to connect Azure federated root database and apply federation in entity framework?

107

How do I create a trace in sql server?

1026

How does index makes search faster?

968

explain different types of constraints? : Sql server database administration

949

Explain insert into select statement?

946

What are differences in between sql server 2012 and sql server 2016?

1035

How you can change the database name in SQL SERVER?

1188

How to delete a database in ms sql server?

1219

can you implement data mining in SSRS?

148

How to encrypt data between dialogs?

1094

Can we store videos inside the sql server table?

972

Why would you call update statistics?

1006

What is the cpu pressure?

1031