Script to generate all attributes about an Oracle table

From: <jchoi_at_sunnyvale.is.lmsc.lockheed.com>
Date: 1996/10/31
Message-ID: <846724617.6907@dejanews.com>#1/1

I am looking for a script that will generate a sql script that will re-create an Oracle table. The script should generate:

• All table column definitions, including DEFAULT value clause if there is one.
• All Triggers
• All Constraints, including ON DELETE CASCADE clause if there is one
• All Index definitions

Currently I am using a script called recreatetbl_source.sql, but it fails to pick up ON DELETE CASCADE and DEFAULT Values and once in a while does not pick up the index definitions.

---

This article was posted to Usenet via the Posting Service at Deja News: http://www.dejanews.com/ [Search, Post, and Read Usenet News!] Received on Thu Oct 31 1996 - 00:00:00 CST