To view DDL

Susanta · Active User Joined: 17 Nov 2009 Posts: 126 Location: India

Is it possible to view DDL staements for already created tables in DB2 Catalog?

Please suggest.

sushanth bobby · Posted: Mon Apr 12, 2010 5:40 pm

Ofcourse Yes, If you have RC/Query or with other tools also its possible i guess. What tool do you have in your place ?

Sushanth

agkshirsagar · Posted: Mon Apr 12, 2010 11:33 pm

DCLGEN also has the DECLARE TABLE statement which can be considered as DDL. You have to let us know what you are trying to find out from the DDL then we may be able to give better suggestions.

Susanta · Active User Joined: 17 Nov 2009 Posts: 126 Location: India

I actually want to know the constraints of any table which were mentioned by create or alter DDL statements.

Thanks.

agkshirsagar · Posted: Tue Apr 13, 2010 8:12 pm

Constraint information can be found out from the catalog tables.
Click Here for more information.
Every site I have worked for had a metadata store/db2 cross reference where I could refer for more information about any existing table. Talk to your peers/seniors in the project, to find out if you have equivalent alternative available at your site.