Can you DESCRIBE or print a schema?

• Quoting Patel_at_Purccvm.Bitnet to All dated 04-21-94 ***
  > Is there a way to get the create table, create index, .. statements
  > from my database?
  

The export utility can create an export file containing SQL statements necessary to create everything in the database, including or excluding data. The resultant file can only be used by the import utility, but it is fast and requires almost no effort, aside from obtaining the proper username/password.

If you need the statements in ASCII, you can get everything you need from the data dictionary, but you'll have to write it yourself in SQL, or locate a tool that is capable of this, such as Oracle CASE, which can read the data dictionary and generate DDL statements. Received on Fri Apr 22 1994 - 11:01:03 CEST