Select FKs and PKs by schema, rename.sql

-- When renaming tables or moving schemas in Entity Framework, EF doesn't rename all related things (like FKs and PKs)
-- This might help to locate those database objects:

-- selects FKs and PKs with schema 'Core.' in their name
SELECT s.name, o.name FROM sys.objects AS o
INNER JOIN sys.schemas AS s ON s.schema_id = o.schema_id
WHERE o.name LIKE '%Slug%' OR o.name LIKE '%PageMetadata%'

-- performs renaming
sp_rename '[Inventory].[FK_Inventory.BaseProduct_Core.PageMetadata_PageMetadata_Id]', 'FK_Inventory.BaseProduct_Navigation.PageMetadata_PageMetadata_Id'