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
- 30472 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
explain different types of constraints? : Sql server database administration
Do you know what are various aggregate functions that are available?
What are the five characteristics of good data?
What languages bi uses to achieve the goal?
What is db stored procedure?
What is an indice?
How to divide query output into multiple groups with the group by clause in ms sql server?
What is self contained multi valued query?
Explain forward - only cursors?
What is side by side migration in sql server?
What are logical database components? : SQL Server Architecture
What are sql servers used for?
What is the maximum row of a size?
How to create a large table with random data for index testing in ms sql server?
How to Update from select query in sql server?
