how to find number of columns in a table in sql server 2000
and 2005 also
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
What are the fixed server level roles? : sql server security
What is the difference between inner join and equi join?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What is etl - extraction, transformation, and loading?
Is the order of columns in the set clause important in ms sql server?
What are sql dirty pages?
What happens if date-only values are provided as date and time literals?
Explain the concept of view and Types of views in SQL server?
Explain about link server in sql server?
Determine how to use the inserted and deleted pseudo tables?
Where sql server user names and passwords are stored in sql server? : sql server database administration
How to backup encryption key ?
Can we do dml on views?
What is field with example?
Why olap is used?