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
