ajit_cus wrote: > > 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
In the meantime I checked this FK-effect. There is a strange remain of older versions, which will result in the effect mentioned. The NOT NULL-clause 'eats' the constraint-name which was meant to belong to the FK-constraint. Will be fixed soon. Elke > -----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 > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
