Re: Can you DESCRIBE or print a schema?

In article <94111.130642PATEL_at_purccvm.bitnet>, <PATEL_at_PURCCVM.BITNET> wrote:
>Is there a way to get the create table, create index, .. statements from
>my database?

Two simple ways to do this.

	(1)  exp / full=y rows=n file=norows.dmp grants=y
	     imp / file=norows.dmp indexfile=schema.sql

	This will generate a file called schema.sql with the create index
	and create table statements.  The create table statements will have
	REM in front of them.

	(2) Get a copy of the IOUG utilities diskette from your local User
	Group.  This contains utilities (SQL scripts) to extract the DDL
	in a much nicer format than the exp/imp method.

Regards,
Andrew.

-- 
--------------------------------------*---------------------------------------
N. Andrew May.                        | Database Administrator
Coles-Myer Ltd                        | These are my humble opinions alone.
53 Hoddle Street, Collingwood,        | Tel: +61 3 483 7389.  Fax: 483 7381