--To generate DDL for all DB2 Database Objects

1. Highlight the applicable database

2. Right click the applicable database

3. Click "Generate DDL"

4. Check only "Database Objects"

5. Click "Object" tab

6. Select User

7. Select Schema

8. Click "Generate"

*** Don't put a check next to "Generate DDL for selected tables only". You can click "Save" and save it to a .txt file. Then you can go thru the output .txt file searching on index and cut and paste.


Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]

DB2 & UDB email list listserv db2-l LazyDBA home page