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
What is the standby server?
What is table join?
What is an expression in ms sql server?
How adventureworkslt tables are related?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Is it ok to shrink transaction log?
How to insert multiple rows with one insert statement in ms sql server?
What are sub reports?
What are cursors in ms sql server?
Does hive support indexing?
How to display a past time in days, hours and minutes?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
How to create a new schema in a database?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
How can you insert null values in a column while inserting the data?