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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

how can i view structure of table in sql server? tell me
that query.

Question Posted / ram

Answer Posted / ram

sp_help <table name>

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create percentile function?

159

Which tcp/ip port does the sql server run on? How can it be changed?

1108

Why would you call update statistics?

1072

How do I create a partition table in sql server?

1182

Explain transaction server consistency?

1018

How do I install only the client tools of sql server 2000?

1126

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

979

what's the information that can be stored inside a bit column? : Sql server database administration

1086

What the different types of Replication and why are they used?

1129

Explain some stored procedure creating best practices or guidelines?

1002

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1999

What is the purpose of the tempdb database?

1045

How many databases can we create in a single server?

209

What is SQL Azure Firewall?

136

What are the recovery models for a database?

1146