Table Structure Question

From: Kian Lee <ooiklnews_at_yahoo.com>
Date: Fri, 20 Oct 2000 05:03:15 GMT
Message-ID: <8sojmh$ccd$1@nnrp1.deja.com>

How do I grep all the table structure including the constraints (primary key) in an Oracle Database with the "create table" scripts? So that I can create the whole set of table in other machines. For example, in IBM DB2 there is a command "db2look", it will grep all the table structure with the create table script and output into a file.

Thanks in advance.

Regards,
Kian Lee

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 20 2000 - 00:03:15 CDT