[dbsrgits/SQL-Translator.git] / t / data / oracle / create2.sql

  CREATE TABLE USER1.TABLE1
   (	FIELD_ID NUMBER(19,0) NOT NULL ENABLE,
	OTHERFIELD NUMBER(19,0) NOT NULL ENABLE,
	 CONSTRAINT FK_OTHERFIELD FOREIGN KEY (OTHERFIELD)
	  REFERENCES USER1.TABLE2 (ID) ON DELETE CASCADE ENABLE,
	 CONSTRAINT FK_FIELD_ID FOREIGN KEY (FIELD_ID)
	  REFERENCES USER1.TABLE3 (ID) ON DELETE CASCADE ENABLE
   ) ;
Commit	Line	Data
32d8b258	1	CREATE TABLE USER1.TABLE1
	2	( FIELD_ID NUMBER(19,0) NOT NULL ENABLE,
	3	OTHERFIELD NUMBER(19,0) NOT NULL ENABLE,
	4	CONSTRAINT FK_OTHERFIELD FOREIGN KEY (OTHERFIELD)
	5	REFERENCES USER1.TABLE2 (ID) ON DELETE CASCADE ENABLE,
	6	CONSTRAINT FK_FIELD_ID FOREIGN KEY (FIELD_ID)
	7	REFERENCES USER1.TABLE3 (ID) ON DELETE CASCADE ENABLE
	8	) ;