?? foreignkey.vm
字號:
#### The following will only work for non-circular references## if you have a dependancy chain, you will need to use## ADD CONSTRAINT syntax (with INITIALLY DEFERRED)## which is sticky and version dependant###foreach ($fk in $table.ForeignKeys)ALTER TABLE $table.Name ADD CONSTRAINT $fk.Name FOREIGN KEY ($fk.LocalColumnNames) REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames)#if ($fk.hasOnUpdate()) ON UPDATE $fk.OnUpdate#end#if ($fk.hasOnDelete()) ON DELETE $fk.OnDelete #end;#end
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -