Source
SnowConvert AI - SQL Server-Azure Synapse - ALTER
Modifies a table definition by altering, adding, or dropping columns and constraints. ALTER TABLE also reassigns and rebuilds partitions, or disables and enables constraints and triggers.
SnowConvert AI - SQL Server-Azure Synapse - System Tables
Contains a row per object that is a FOREIGN KEY constraint (SQLServer Documentation).