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

What are drilldown reports?

86


How to resolve the orphan use problem? : sql server security

532


Explain what is it unwise to create wide clustered index keys?

550


Explain powershell included in sql server 2008?

617


How can we use ConnectorJ JDBC Driver with MS SQL?

571






What are policy management terms?

568


What is the difference between a stored procedure and a user defined function?

550


What is 5nf in normalization form?

578


What is the cartesian product of table?

553


What is SQL Azure Federations?

98


Can binary strings be converted into numeric or float data types?

563


What the different components in replication and what is their use?

519


What is user-defined scalar function?

563


How many triggers are possible per table?

633


What are the tool windows in sql server management studio? : sql server management studio

626