熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

外鍵約束和參紹約束的實例腳本

2013-11-13 15:46:28  來源: Oracle 

  外鍵約束和參紹約束的實例腳本

  

  /* 外鍵約束和參紹約束 pubs數據庫的CarIfo表創建外鍵約束參紹CarFactory表的主鍵ID */ USE Pubs GO /*不顯示行數*/ SET NOCOUNT ON GO /*創建示例表*/ IF EXISTS (SELECT * FROM dbosysobjects WHERE id = object_id(NCarInfo) AND OBJECTPROPERTY(id NIsUserTable) = ) DROP TABLE CarInfo GO CREATE TABLE CarInfo( Car_ID CHAR () Name CHAR () Type CHAR () Driver_Type CHAR () ) IF EXISTS (SELECT * FROM dbosysobjects WHERE id = object_id(NCarFactory) AND OBJECTPROPERTY(id NIsUserTable) = ) DROP TABLE CarFactory GO CREATE TABLE CarFactory( ID CHAR () NOT NULL Name CHAR () PostCode CHAR () Telphone CHAR () Address CHAR () ) GO ALTER TABLE CarFactory ADD CONSTRAINT PK_Car_ID PRIMARY KEY NONCLUSTERED (ID) GO ALTER TABLE CarInfo WITH NOCHECK ADD CONSTRAINT Car_id_link FOREIGN KEY (Car_ID) REFERENCES CarFactory(ID) GO USE master EXEC sp_dboption Pubs dbo use only TRUE GO USE Pubs SET NOCOUNT ON GO


From:http://tw.wingwit.com/Article/program/Oracle/201311/17284.html
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.