There is now a level 0....
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
SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates