我有桌子:CompanyId(uniqueidentifier), TypeId(int), DateCAST(DATEADD(month, DATEDIFF(month, 0, Date), 0) AS date) AS MonthStarts, WHEN TypeId= 1 THEN '4 Search views'
WHEN TypeId = 2 THEN '5
TypeId列是not null。[TypeId] = 1并设置null:ALTER TABLE [dbo].'FK_MyTable_ObjTypes' is dependent on column 'TypeId'.如果列是FK,我不能使用后排表吗?GO
ALTER TABLE [dbo].放下并重新创建约束帮助我。这是我