how to find number of columns in a table in sql server 2000
and 2005 also
Answer Posted / saravanan p
select count(column_Name) from information_schema.columns
where table_name='tableName'
Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
What are the different types of replication you can set up in sql server?
What is read committed?
What is cached report?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
what are the three command line utilities and what are their primary functions?
What are the recovery models for a database?
What are the different types of collation sensitivity?
Do you know what is blocking?
How to create a user to access a database in ms sql server using "create user" statements?
What do you understand by triggers and mention the different types of it?
How to download and install microsoft sql server management studio express?
Difference between primary key and clustered index?
Explain query editor regions
How to generate create table script on an existing table in ms sql server?
What is an example of a foreign key?