sp_help tablename another command is select name from syscolum

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

Question Posted / naren

Answer Posted / naren

sp_help tablename

another command is

select name from syscolumns where id=object_id
('table_name')

Is This Answer Correct ?

6 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What do you mean by tablesample?

1031

How to get a list of columns using the "sys.columns" view in ms sql server?

917

How will you know when statistics on a table are obsolete?

1031

What is a view in sql?

926

Explain filtered indexes benefits?

950

What is best institute to Learn DotNET And SQL in chennai?

2113

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1039

How sql server enhances scalability of the database system?

1110

What are the different kinds of ssrs reports?

206

What is sql server 2000 work load governor?

975

What information is maintained within the msdb database?

924

how many triggers you can have on a table? : Sql server database administration

903

What is the difference between join and inner join?

952

How do you implement session management in SQL Server mode?

1022

Differentiate between a primary key and a unique key.

998