Here is the T-SQL to check the FK constraint and display its name and the parent table.
select name,OBJECT_NAME(parent_object_id) from sys.objects where object_id in
( select fk.constraint_object_id from sys.foreign_key_columns as fk
where fk.referenced_object_id =
(select object_id from sys.tables where name = 'region')
)
Then we can use alter table statement to remove it from parent table.
alter table nation drop nation_region_fk
0 comments:
Post a Comment