Re: whats wrong with my script ?

[Thomas Markus]

Hi,

that example works with my 7.3.0.23 (Linux i686 2.4.18)
but try to reference pks


D S wrote:
> Hi,
> I am not sure if this is a known issue or not. I have 3 tables, 
> and two tables have foreign key references to the first table.
> If I insert a row in the first table, I cant delete it anymore 
> even if there is no foreign key constraint on that row. Please 
> let me know I am doing wrong !
> 
> Thanks and regards,
> ~dil
> 
> CREATE TABLE TABLE_A
> (
> 	COL1	INTEGER					
> 	CONSTRAINT TABLE_A_PK     PRIMARY KEY,
> 	COL2	VARCHAR(32)		NOT NULL
> 	CONSTRAINT TABLE_A_UQ     UNIQUE
> )
> //
> 
> CREATE TABLE TABLE_B
> (
> 	COL2	VARCHAR(32)				
> 	CONSTRAINT TABLE_B_FK REFERENCES TABLE_A(COL2)
> )
> //
> 
> CREATE TABLE TABLE_C
> (
> 	COL1	INTEGER			NOT NULL
> 	CONSTRAINT TABLE_C_FK REFERENCES  TABLE_A(COL1)
> )
> //
> 
> 
> INSERT INTO TABLE_A VALUES (1, 'Default')
> //
> 
> -- this statement doesnt work
> DELETE FROM TABLE_A
> //
> 
> 
> 
> 
> 
> -- these statements work
> CREATE TABLE TABLE_D
> (
> 	COL1	INTEGER					
> 	CONSTRAINT TABLE_A_PK     PRIMARY KEY,
> 	COL2	VARCHAR(32)		NOT NULL
> 	CONSTRAINT TABLE_A_UQ     UNIQUE
> )
> //
> INSERT INTO TABLE_D VALUES (1, 'Default')
> //
> DELETE FROM TABLE_D
> //
> 
> 
> 
> ________________________________________________
> Get your own "800" number
> Voicemail, fax, email, and a lot more
> http://www.ureach.com/reg/tag
> _______________________________________________
> sapdb.general mailing list
> sapdb.general@stripped
> http://listserv.sap.com/mailman/listinfo/sapdb.general


-- 
Thomas Markus
Tel: [phone] - 18
mailto:t.markus@stripped
Proventis GmbH
Torellstr. 1
10243 Berlin