How to create table DDL for a table without storage options (4254451)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How to create table DDL for a table without storage options
Description

How can to go about creating DDL of all tables without the STORAGE options.
Resolution

1. Go to you schema browser
2. Right click on the tables and select Create Script
3. Click on Script Options tab and then Storage Objects tab
4. Uncheck the option Storage Clauses and both option under it. If you only want Tablespace, then check the "Tablespace only"
5. Click on OK and test the issue.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title