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

Answer Posted / mohan

None of the above answer can result the columns which is
having auto incremented (Identity).
Also if a column is binded to user defined data type that
is also excluded....
So the Correct Number of column cannot be resulted in the
above answers.........

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to rename an existing column with sql server management studio?

678


What are the disadvantages of using the stored procedures?

699


What do you mean by a dependent functionality in a build?

828


Define primary key?

874


What is the command used to check locks in microsoft sql server?

717






What is “asynchronous” communication in sql server service broker?

714


How to disable a login name in ms sql server?

746


What is role playing dimension with two examples? : sql server analysis services, ssas

772


What is server-level principal?

114


Explain the phases a transaction has to undergo?

727


what is the different types of backups available in sql server? : Sql server database administration

645


What is cdc in sql server?

734


Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

96


Explain differences between web edition and business edition?

115


Explain view in sql server?

816