how to find number of columns in a table in sql server 2000
and 2005 also
- 16 Answers
- 28172 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / vidit tyagi
SELECT Count(*)As Coloumns
FROM SysColumns
Where ID =
(SELECT ID FROM SysObjects Where Name = 'TableName')
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
Tell me what is a linked server?
What do we have to check in database testing?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
Write the syntax for stuff function in an sql server?
what is normalization? Explain different levels of normalization? : Sql server database administration
What is temporary stored procedure?
What are different types of table joins?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What are the differences between stored procedure and view in sql server?
What is self contained sub query?
What are the types of stored procedures in an sql server?
How do you run a trace?
Ways to improve the performance of a SQL Azure Database?
What are the different types of collation sensitivity?
What is table value parameters (tvp)?
