SQL語句添加外鍵限制

ALTER TABLE [Enviroment].[dbo].[T_Bas_EnterpriseData_I] ALTER COLUMN [code_pollute] NVARCHAR(12) NOT NULL

  ALTER TABLE [Enviroment].[dbo].[T_Bas_EnterpriseData_I]  WITH CHECK ADD FOREIGN KEY(code_pollute)

    REFERENCES [Enviroment].[dbo].[T_Bas_EnterList]

  GO