以下是我用企业管理器生成的sql代码。
看到没有,主键,外键,和 ON DELETE CASCADE 。
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CadFile_Cad]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[CadFile] DROP CONSTRAINT FK_CadFile_Cad
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Cad]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Cad]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CadFile]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CadFile]
GO
CREATE TABLE [dbo].[Cad] (
[CadId] [int] NOT NULL ,
[ManageNo] [varchar] (10) NOT NULL ,
[PicNo] [varchar] (10) NULL ,
[PicName] [varchar] (20) NOT NULL ,
[DraftMan] [varchar] (10) NOT NULL ,
[ExamMan] [varchar] (10) NULL ,
[DraftDate] [datetime] NULL ,
[PigeDate] [datetime] NULL ,
[FileFormat] [char] (3) NOT NULL ,
[ModifyDate] [datetime] NULL ,
[ModifyMan] [varchar] (10) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[CadFile] (
[CadID] [int] NOT NULL ,
[FileName] [varchar] (50) NOT NULL ,
[FileSize] [int] NOT NULL ,
[BlobFile] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Cad] WITH NOCHECK ADD
CONSTRAINT [Cad_PK] PRIMARY KEY CLUSTERED
(
[CadId]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CadFile] ADD
CONSTRAINT [FK_CadFile_Cad] FOREIGN KEY
(
[CadID]
) REFERENCES [dbo].[Cad] (
[CadId]
) ON DELETE CASCADE NOT FOR REPLICATION