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

sql source used to create tables

Status
Not open for further replies.
dooge

dooge

Programmer
Jun 30, 2003
4
US
In oracle's dbastudio, when you select a table it shows the SQL text used to create the table. Where is this stored in the database (if it is)?
 
Sort by date Sort by votes
It's created dynamically.
In 9i you can run the PL/SQL dbms_metadata to create the DDL for you.
Otherwise you will have to create the code yourself looking at user_tables, user_tab_columns ...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
783
Andrzejek
Andrzejek
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
701
SkipVought
S
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
4K
carp
carp
Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
659
Livia8
Livia8
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
302
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top