Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Viewing Table Structure

Status
Not open for further replies.
gust1480

gust1480

Programmer
Mar 19, 2002
148
PH
How can I view a certain table structure using sql scripts? Thanks much!
 
Sort by date Sort by votes
Code: 
SELECT * FROM MyDataBase.Information_Schema.columns WHERE Table_Name = 'MYTABLE_NAME'

Borislav Borissov
 
Upvote 0 Downvote
For viewing only:
Code: 
sp_help 'MYTABLE_NAME'

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]
[banghead]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
convert hierarchy structure to parent children pair please... 1
2
Replies
22
Views
2K
mikrom
mikrom
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
867
BobSuruncle
BobSuruncle
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
709
Chris Miller
Chris Miller
Billz66
  • Locked
  • Question
need to udate table entry with number containing a *
Replies
11
Views
530
Chris Miller
Chris Miller
eboughey1008
  • Locked
  • Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
408
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top