建立M-D表格需使用的FK寫法

  • 張貼者： Iris
  • 2009年2月10日 星期二

建立M-D表格需使用的FK寫法
(Ym varchar2(5) ,
EgNo varchar2(8) ,
Pld1 varchar2(2) ,
Pld2 varchar2(2) ,
TxCo varchar2(2),
TxEmp varchar2(10),
TxMch varchar2(30) ,
TxDat varchar2(7) ,
TxTm varchar2(6) ,
Constraint fk1_TD Foreign key(ym,egno) References &user..TM(ym,egno) ON DELETE CASCADE,
Constraint pk_TD Primary key(Ym,EgNo,Pld1,Pld2));

 

Reader Comments

張貼留言



訂閱： 張貼留言 (Atom)

Welcome to Glued Ideas Subtle For Blogger

Thank you for taking the time to visit my blog! Take a second to peak around and check out some of my previous posts. Of course, I would love to find out what you think as well, so make sure to comment. See you around!

Blogger Templates by Blog Forum

網誌