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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

describe table

Status
Not open for further replies.
shaoji

shaoji

Programmer
Mar 22, 2004
10
US
Hi,
A basic question: what command should I use look the elements and their format in a table? what command should i use to check what tables there are in a database?
Thanks.
Shaoji
 
Sort by date Sort by votes
help database mydb; -> all objects within a DB
help table/view/macro/procedure xxx -> column/parameter info

For a view it might be better to use
help column myview.*;

show table/view/macro/procedure xxx; -> create statement

Check the "SQL Reference Data Definition Statements" manual, "Chapter 4:
SQL Help and Database Object Definition
Tools: HELP and SHOW"

Dieter
 
Upvote 0 Downvote
Dieter,
Thank you very much for your help.
Shaoji
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Janet Charbula
  • Locked
  • Question
Finding a value within a table
Replies
0
Views
119
Janet Charbula
Janet Charbula
jholl
  • Locked
  • Question
Create Volatile Table in Teradata is showing 0 rows being processed
Replies
0
Views
135
jholl
jholl
EasyBoy2
  • Locked
  • Question
Insert into second table from first table
Replies
0
Views
96
EasyBoy2
EasyBoy2
njohn14
  • Locked
  • Question
Updating a table, the update must be ignore if it causes a duplicate primary key
Replies
1
Views
47
njohn14
njohn14
rdelloro
  • Locked
  • Question
VOLATILE TABLE
Replies
0
Views
35
rdelloro
rdelloro

Part and Inventory Search

Sponsor

Back
Top