how to find number of columns in a table in sql server 2000
and 2005 also
- 16 Answers
- 26516 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / dharmendra k. dixit
@Anshul..
Bro..through your code u can obtain the Total numbers of
rows in your Table.
---------------------------------
For getting Total Columns i will use this:
SELECT Count(*)As Coloumns
FROM Sys.SysColumns
Where ID =
(SELECT ID FROM Sys.SysObjects Where Name = 'YourTableName')
| Is This Answer Correct ? | 34 Yes | 8 No |
Post New Answer View All Answers
What is sql profiler. What are the default templates with it? : sql server database administration
Explain can you implement data mining in ssrs?
Tell me what is log shipping?
explain databases and sql server databases architecture? : Sql server database administration
How to get a list all databases on the sql server?
What is temporal table?
Why we use trigger in sql server with example?
What is @@error in sql?
what's the difference between a primary key and a unique key? : Sql server database administration
How can you tell if a database object is invalid?
What is a transactions?
What are the different types of sub-queries?
What is bit data type? What's the information that can be stored inside a bit column?
What are xml indexes?
What is nonclustered index with included columns ?
