how to find number of columns in a table in sql server 2000
and 2005 also
Answer Posted / sujitha
SELECT DISTINCT SYS.NAME,COUNT(*) FROM SYSOBJECTS SYS
INNER JOIN SYSCOLUMNS SYSCOL ON SYSCOL.ID=SYS.ID
WHERE SYS.XTYPE='U' GROUP BY SYS.NAME
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How to list all tables in the database using odbc_tables()?
What is 1nf 2nf and 3nf?
Explain magic tables in sql server?
How to write a query with a left outer join in ms sql server?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
Call by value and call by reference in procedure and function, with NOCOPY.
What is the sql server 2000 version number?
What is truncate table?
How do you send email on SQL Server?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
How many types of stored procedures are there in sql server?
Explain what is the function of sql server agent windows service?
What is a database table?
What are the requirements on sql server network connections?
How to defragment table indexes?