469,942 Members | 2,568 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,942 developers. It's quick & easy.

news group for DB2 sql language ?

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 !

--
Jean-Luc M.
Jan 2 '07 #1
1 1025
Jean-Luc M. wrote:
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.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Jan 2 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Cameron Laird | last post: by
reply views Thread by Gabriel Genellina | last post: by
reply views Thread by Gabriel Genellina | last post: by
reply views Thread by Gabriel Genellina | last post: by
reply views Thread by Gabriel Genellina | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.