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? create table test2( c2 varchar(20) NOT NULL CONSTRAINT CTEST2FK REFERENCES test1(c1) ) ##SQL studio shows the foreign key constraint ##But constraint name is TEST1_TEST2 ##Why?? drop table test2 // create table test2( c2 varchar(20) NOT NULL, CONSTRAINT CTEST2FK FOREIGN KEY (c2) REFERENCES test1(c1) ) ##Now SQLStudio says referential constraint name is ##CTEST2FK,thats nice.... :-) Why this weird behavior?? and how do i drop a PK.I assume i'm missing something... regards, Ajit _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
