T-SQL筆記24_ 針對既有table增加Identity並設置PK的約束_對既有column進行data type更改_查找特定某張表外鍵引用

 針對既有table增加Identity並設置PK的約束

ALTER TABLE dbo.{目標table名稱} ADD {流水號索引欄位名稱} INT IDENTITY
ALTER TABLE dbo.{目標table名稱} ADD CONSTRAINT PK_{目標table名稱} PRIMARY KEY({流水號索引欄位名稱})




對既有column進行data type更改

ALTER TABLE {目標table名稱}ALTER COLUMN  {目標欄位名稱} {指定之Column DataType}

查找特定某張表外鍵引用

 select fk.name,fk.object_id,object_name(fk.parent_object_id) as referencetablename  
 from sys.foreign_keys as fk  
 join sys.objects as o on fk.referenced_object_id=o.object_id  
 where o.name='{表名}'  

刪除被引用的該表外鍵

alter table dbo.被引用的表名 drop constraint 外來鍵名  

Ref:

https://linriva.pixnet.net/blog/post/47900516

How to remove foreign key constraint in sql server?

https://stackoverflow.com/questions/12489762/how-to-remove-foreign-key-constraint-in-sql-server

SQL SERVER如何Truncate具有Foreign Key的資料表

https://emn178.pixnet.net/blog/post/82715779

解決無法刪除表，提示被外來鍵約束引用

https://www.w3study.wiki/a/202106/171643.html

http://codeformatter.blogspot.com/

http://cw1057.blogspot.com/2012/07/blogger-format-sample-codes-in-blogs.html