how to find number of columns in a table in sql server 2000
and 2005 also
- 16 Answers
- 28206 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / surbhi
SELECT count(*) FROM INFORMATION_SCHEMA.COLUMNS where
table_name='tablename'
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Which sql server is best?
What are the different types of locks in the database?
What is the difference between varchar and nvarchar datatypes?
What’s the distinction between dropping a info and taking a info offline?
What are the restrictions that views have to follow? : SQL Server Architecture
Do you know what are different types of replication in sql server?
What is use of except clause? How it differs from not in clause?
What is the difference between drop table and truncate table?
What is the difference between stored procedure and functions?
How to replace given values with null using nullif()?
 Explain what is sql override for a source taLle in a mapping?
What is 2nf normalization form?
What is pessimistic concurrency?
Explain Normalization and DE normalization
Please explain what is “asynchronous” communication in sql server service broker?
