news group for DB2 sql language ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jean-Luc M. - 02 Jan 2007 09:34 GMT

Hi and happy new year

I search a news group for DB2 sql language .

(I need to find primary key on a table name and delete it)

Thanks

Jean-Luc !

Signature

Jean-Luc M.

Reply to this Message

Knut Stolze - 02 Jan 2007 10:59 GMT

> Hi and happy new year
>
> I search a news group for DB2 sql language .

This is the one here...

> (I need to find primary key on a table name and delete it)

Have a look at the SYSCAT.TABCONST catalog view. It lists all constraints,
including PK, and you can use that to construct the respective ALTER
TABLE ... DROP CONSTRAINT ... statement.

Signature

Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Reply to this Message