如何更改列CorporateID数据类型它是一个外键 [英] how can i change the column CorporateID datatype it is a foreign key

问题描述

CREATE TABLE [dbo].[tblVehicleCategory](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [CategoryName] [nvarchar](50) NULL,
    [NumberOfSeats] [int] NOT NULL,
    [Description] [nvarchar](max) NULL,
    [CorporateID] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_tblVehicleCategory] PRIMARY KEY CLUSTERED
(
    [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[tblVehicleCategory]  WITH CHECK ADD FOREIGN KEY([CorporateID])
REFERENCES [dbo].[tblCorporateProfile] ([CorporateID])
GO

推荐答案

首先删除约束FK，然后使用适当的语法更改数据类型并再次创建FK。





问候，

Mubin

Hi ,

First drop the constraint FK, then change data type and create FK again using appropriate syntax.


Regards,
Mubin

这篇关于如何更改列CorporateID数据类型它是一个外键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！