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 Rhinorhino 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
Joined
Mar 19, 2002
Messages
148
Location
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 Question
convert hierarchy structure to parent children pair please...
2
Replies
22
Views
3K
mikrom
mikrom
grnzbra
  • Locked
  • Question Question
How Do I Add Column to Middle of Table
Replies
4
Views
1K
BobSuruncle
BobSuruncle
BobThornton
  • Locked
  • Question Question
Drop a table based on the count of records in another table
Replies
13
Views
1K
Chris Miller
Chris Miller
Billz66
  • Locked
  • Question Question
need to udate table entry with number containing a *
Replies
11
Views
858
Chris Miller
Chris Miller
eboughey1008
  • Locked
  • Question Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
643
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top