Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 is nested transaction?

1106


What is rank function?

1036


What is use of except clause? How it differs from not in clause?

1022


What are the restraints imposed on the table design by a merge replication?

1040


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1514


What do you understand by user-defined function in the sql server?

960


What is table level trigger?

1026


What are the advantages of log shipping?

998


What is ddl command?

987


How can change procedure in sql server?

1073


What is the difference between createstatement and preparedstatement?

948


What are entities and relationships?

976


What is the difference between system objects and user objects?

1168


How to list all tables in the database using odbc_tables()?

1052


How to download and install microsoft .net framework version 2.0?

1142