File: create2.sql

package info (click to toggle)
libsql-translator-perl 0.11020-1
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 4,544 kB
  • ctags: 2,126
  • sloc: perl: 67,105; sql: 3,809; xml: 233; makefile: 7
file content (8 lines) | stat: -rw-r--r-- 336 bytes parent folder | download | duplicates (9) 
1
2
3
4
5
6
7
8
 
  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
   ) ;