CNCEC_SUBQHSE_WUHUAN/DataBase/版本日志/SGGLDB_WH_2024-07-01-bwj.sql

9 lines
368 B
Transact-SQL

ALTER TABLE Comprehensive_NCRManagement ADD Supervisor nvarchar(50)
go
ALTER TABLE [dbo].[Comprehensive_NCRManagement] WITH CHECK ADD CONSTRAINT [FK_Comprehensive_NCRManagement_Sys_User] FOREIGN KEY([Supervisor])
REFERENCES [dbo].[Sys_User] ([UserId])
GO
ALTER TABLE [dbo].[Comprehensive_NCRManagement] CHECK CONSTRAINT [FK_Comprehensive_NCRManagement_Sys_User]
GO