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

Using the customer, and order table in northwind database, please write a query to produce xml?

1119

What is an indice?

1085

What happens when converting big values to numeric data types?

1229

what kind of lan types do you know? : Sql server database administration

1023

Can we update data in a view?

1081

How to identify current user in ssrs report?

408

How to declare and use cursor variables?

1255

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1260

What are a scheduled jobs?

996

What is the difference between truncate and delete commands?

1110

What is sql sandbox in sql server?

1297

What is triggers and its types?

1069

what is a check constraint?

1174

Do you know how to make remote connection in database?

1010

How do I determine how many instances of sql server are installed on a computer?

1059