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
- 7 Answers
- 14277 Views
- HCL, Virtusa, I also Faced
- E-Mail Answers
Answer Posted / anand k
--FOR Given Table Name.
SELECT COUNT(*) FROM SYS.COLUMNS
WHERE ID = OBJECT_ID('<TABLENAME>')
--For All UD Tables in the current DB
SELECT OBJ.NAME,COUNT(*)
FROM SYS.COLUMNS COL,SYS.OBJECTS OBJ
WHERE OBJ.OBJECT_iD = COL.OBJECT_ID
AND TYPE = 'U'
GROUP BY OBJ.NAME
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
How to configure odbc dsn with different port numbers?
What is a trace frag?
What is difference between primary key and foreign key?
How do I perform an unattended install of sql server 2000?
How to write a query with an inner join in ms sql server?
What is self contained sub query?
What is Federation and Federation Member?
What are orphan records?
How to define the name and server for a new dsn?
How do you manipulate data?
How do I find my localdb version?
How to invoke a trigger on demand?
What are the differences between substr and charindex in sql server.
What is sub-query in sql server?
What are sub reports?
