开发者

Edit SQL server column data type

开发者 https://www.devze.com 2023-02-03 05:35 出处:网络
I\'ve a an int column that I want to change to bigint but this column have alot of references is there any way to alter the column and all referenced columns or I\'ve to drop and recreate all con开发者

I've a an int column that I want to change to bigint but this column have alot of references is there any way to alter the column and all referenced columns or I've to drop and recreate all con开发者_开发技巧straints?

thanks


No, you have to drop and recreate primary key and foreign key constraints.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号