Interested to Buy Any Domain ? << Click Here >> for more details...
how to find number of columns in a table in sql server 2000
and 2005 also
- 16 Answers
- 30645 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / anand k
--Count of Columns
SELECT COUNT(*) NO_OF_COLUMNS
FROM SYS.COLUMNS
WHERE OBJECT_ID = OBJECT_ID('<TableName>')
ORDER BY Column_ID
--Column Names
SELECT [NAME]
FROM SYS.COLUMNS
WHERE OBJECT_ID = OBJECT_ID('<TableName>')
ORDER BY Column_ID
| Is This Answer Correct ? | 14 Yes | 6 No |
Post New Answer View All Answers
What do you mean by sql server 2005 express management tools?
How to sort query output in descending order in ms sql server?
What is usually the first word in a sql query?
What is after dml trigger?
How to use column default values in insert statements in ms sql server?
How to drop existing indexes in ms sql server?
Why people hate cursor?
What is the purpose of sql profiler in sql server?
What guidelines should be followed to help minimize deadlocks?
What is ems sql management studio? : sql server management studio
Explain what is the function of sql server agent windows service?
What is dml command?
Explain atomicity?
Explain what are partitioned views and distributed partitioned views?
How to recompile stored procedure at run time?
