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
How can I get data from a database on another server?
What is the largest component inside a field?
What is an identity column in insert statements?
How do I create a stored procedure in dbml?
Explain an incremental backup?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
Mention what are the core components of ssrs?
When to use null data driven subscription?
Do you know what is lock escalation?
What is the difference between clustered index and primary key?
Explain what is meant by replication of database?
How to generate create procedure script on an existing stored procedure?
1 01 101 01010
How to rename an existing column with sql server management studio?
What Are the Main Features of SQL Azure?