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
How to create a view with data from multiple tables?
What is efficiency data?
What is change data capture (cdc) feature?
How many servers can we create in a single subscription?
What are the different types of collation sensitivity in sql server?
How many categories of data types used by sql server?
Define tool Manage Statistics in SQL Server 2000 query ?
What is the difference between commit and rollback?
What is the downside of using udf?
What is the contrast between sql and pl/sql?
Explain the cursor lock types?
How to use order by with union operators in ms sql server?
How to get the definition of a view out of the sql server?
What do you understand by coalesce in sql server?
How many replicas are maintained for each SQL Azure database?