SQL Server TSQL: NOCHECK Foreign Key inside CREATE TABLE

cvxl0en2 于 2023-03-17 发布在其他

关注(0)|答案(1)|浏览(160)

I want to add a foreign key constraint inline with my CREATE TABLE statement. However, I also want to include the NOCHECK attribute. Can this be done in one pass inside the CREATE TABLE statement? I can't seem to find a good example.

So, something like:

CREATE TABLE dbo.SampleTable (
   [ID] INT IDENTITY (1,1) NOT NULL,
   [ParentSampleTableID] INT NOT NULL,
   <NOCHECK> CONSTRAINT [FK_SampleTable_ParentSampleTable] FOREIGN KEY (ParentSampleTableID) REFERENCES dbo.ParentSampleTable ([ID])
)

Any ideas?

sql-server

来源：https://stackoverflow.com/questions/26000346/tsql-nocheck-foreign-key-inside-create-table

1条答案

按热度按时间

6tdlim6h1#

You cannot add a constraint and disable at table definition level.

You have two options

(1) do not add a constraint at the table definition level and later add the constraint and also disable it using NOCHECK .

CREATE TABLE dbo.SampleTable 
(
    [ID] INT IDENTITY (1,1) NOT NULL,
    [ParentSampleTableID] INT NOT NULL
)
GO   

ALTER TABLE dbo.SampleTable WITH NOCHECK 
    ADD CONSTRAINT [FK_SampleTable_ParentSampleTable] 
        FOREIGN KEY (ParentSampleTableID) REFERENCES dbo.ParentSampleTable ([ID])
GO

(2) Add constraint at table definition level and later disable it:

CREATE TABLE dbo.SampleTable 
(
    [ID] INT IDENTITY (1,1) NOT NULL,
    [ParentSampleTableID] INT NOT NULL,
    CONSTRAINT [FK_SampleTable_ParentSampleTable] 
        FOREIGN KEY (ParentSampleTableID) REFERENCES dbo.ParentSampleTable ([ID])
)
GO

ALTER TABLE dbo.SampleTable 
    NOCHECK CONSTRAINT [FK_SampleTable_ParentSampleTable]
GO

赞(0）回复(0）举报 2023-03-17

我来回答

SQL Server TSQL: NOCHECK Foreign Key inside CREATE TABLE

1条答案

相关问题

热门标签

最新问答