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
- 31077 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 Normalization and DE normalization
Can two different columns be merged into single column? Show practically?
What new data source types were added in ssrs 2014?
What is sql view?
What is user defined stored procedures?
Explain what is analysis service repository?
What is sub-query in sql server? Explain its properties.
What is resultset concur_updatable?
what is hash nonclustered index
What is create command?
How to call a function from a stored procedure in SQL Server ?
How can we remove orphan records from a table?
What command is used to rename the database?
How to list all schemas in a database?
what are user defined datatypes? : Sql server database administration
