how to find number of columns in a table in sql server 2000
and 2005 also

Answer Posted / ashutosh jha

select count (*) from tablename.

Is This Answer Correct ?    7 Yes 134 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference in performance between insert top (n) into table and using top with insert?

628


What is merge join?

653


how you can list all the tables in a database?

631


You want to use a perspective in an mdx query. How do you select the perspective?

172


How to execute stored procedure in select statement sql server?

618






What is a self join in sql server?

688


Do you know what are pages and extents? : SQL Server Architecture

657


Explain cross join or cartesian product in sql?

617


What is RMS migrations?

1787


How to get the definition of a stored procedure back?

616


What is catalog views?

703


Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

787


What you can do to delete a table without the delete trigger firing?

610


Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

659


How to find out what is the default collation in a database?

713