how to find number of columns in a table in sql server 2000
and 2005 also
- 7 Answers
- 12721 Views
- HCL, Virtusa, I also Faced
- E-Mail Answers
Answer Posted / amit
SELECT count(*) NoOfColumns FROM SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name
= 'TableName')
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How to define the name and server for a new dsn?
what is a join and explain different types of joins? : Sql server database administration
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What are the five characteristics of good data?
Define candidate key, alternate key, and composite key.
How to create new table with "create table" statements?
What is the contrast between sql and mysql?
Does sql server use t sql?
What options are available to audit login activity? : sql server security
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What are the differences between union, intersect, and minus operators?
Do you know the cursor optimization tips?
What is bcp? When does it use?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
How to find the list of fixed hard drive and free space on server?
