Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE Table1 (pkcol1 ... PRIMARY KEY, ...);
- CREATE TABLE Table2 (pkcol2 ... PRIMARY KEY, ...);
- CREATE TABLE MtoM_Table1_Table2
- (
- pkcol1 ... REFERENCES Table1,
- pkcol2 ... REFERENCES Table2,
- PRIMARY KEY (pkcol1, pkcol2)
- );
- -- CREATE INDEX fk1_mtom_table1_table2 ON MtoM_Table1_Table2(pkcol1);
- -- CREATE INDEX fk2_mtom_table1_table2 ON MtoM_Table1_Table2(pkcol2);
- CREATE TABLE Table1 (pkcol1 ... PRIMARY KEY, ...);
- CREATE TABLE MtoM_Table1_Table1
- (
- pkcol1 ... REFERENCES Table1(pkcol1),
- akcol1 ... REFERENCES Table1(pkcol1),
- PRIMARY KEY (pkcol1, akcol1)
- );
- -- CREATE INDEX fk1_mtom_table1_table1 ON MtoM_Table1_Table1(pkcol1);
- -- CREATE INDEX fk2_mtom_table1_table1 ON MtoM_Table1_Table1(akcol1);
- CREATE TABLE Table1
- (
- pkcol1 ... /* PRIMARY KEY */,
- fkcol1 ... /* FOREIGN KEY REFERENCES Table1(pkcol1) */,
- ...
- );
- -- CREATE INDEX fk1_table1 ON Table1(pkcol1);
- -- CREATE INDEX fk2_table1 ON Table1(fkcol1);
Add Comment
Please, Sign In to add comment