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

Answer Posted / mohan

Guys.. Why don;t you try for the Columns bided with User
Defined Data Type and try the above queries... and Also try
for the Auto incremented Columns..(Identity)....
Your opinion would change definately....
Try out...
I am sure it doesn't take account of UDT Binded Coulmns

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the standby server?

682


What is table join?

769


What is an expression in ms sql server?

729


How adventureworkslt tables are related?

685


What is the guest user account in sql server? What login is it mapped to it? : sql server security

762


Is it ok to shrink transaction log?

700


How to insert multiple rows with one insert statement in ms sql server?

795


What are sub reports?

170


What are cursors in ms sql server?

792


Does hive support indexing?

715


How to display a past time in days, hours and minutes?

745


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

922


How to create a new schema in a database?

755


What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

763


How can you insert null values in a column while inserting the data?

928