how to find number of columns in a table in sql server 2000
and 2005 also
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
How to create a Master database in SQL server ?
what is difference between NULL and ISNULL in SQL Server 2008?
what is the difference between a primary key and a unique key? : Sql server database administration
What are the types of containers in ssis?
What happens when transaction log is full?
What is a view in sql?
What is sql language?
Explain in details security in SQL azure?
How to list all user defined functions in the current database?
What is the full form of dql?
What are joins in sql and what are the different types of joins?
Explain ranking functions?
How to delete all rows with truncate table statement in ms sql server?
Explain view in sql server?
How to include date and time values in sql statements?