Hmm, I missed the primary key drop..thanks...will look it up ,However whats with the FK constraint name's being generated by sapdb instead of using the one i specify.Or is that too something i missed... Thanks Ajit
-----Original Message----- From: Zabach, Elke [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 2:47 PM To: ajit_cus; [EMAIL PROTECTED] Subject: RE: constraint names in ddl and dropping a PK ajit_cus wrote: > Why is this the way it is?? > > Sapdb 7.3.30 > Here is my test case(queries are in SQLMODE oracle) > > create table test1( > c1 varchar(20), > constraint ctest1PK primary key(c1) > ) > > ## I'm using SQLSTUDIO and dont see my primary key constraint > name anywhere??!! > ## However the column is marked as PK. > ## I cant alter the table to drop the PK using > ## ALTER TABLE DROP CONTRAINT ctest1PK > ## How would i do this? You missed in reference manual --> data definition --> alter table statement --> drop definition the drop primary key, which is written in the syntax definition Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
