sqlserver_reflection.md

Foreign keys

Rename

-- 1. Just the object name as seen in sys.objects:
sp_rename 'FK_Product_Caetgory', 'FK_Product_Category', 'OBJECT'
 
-- 2. Qualified with  the schema:
sp_rename 'Shopping.FK_Product_Caetgory', 'FK_Product_Category', 'OBJECT'
 
-- 3. Qualified with the schema and table:
sp_rename 'Shopping.Product.FK_Product_Caetgory', 'FK_Product_Category', 'OBJECT'

List all whose name doesn't have prefix "FK_"

select 
  fk.table_name, fk.constraint_name
from
  information_schema.referential_constraints rc
inner join information_schema.table_constraints fk
  on rc.constraint_name = fk.constraint_name
where 
  fk.constraint_name not like 'FK[_]%'

Schema of a table (columns, contraints, FKs, etc)

sp_help 'VariationLink'