Get all constraints in sql in specific db ( SQL CONSTRAINTS )

SELECT * FROM sys.objects

WHERE type_desc LIKE ‘%CONSTRAINT’

ALTER TABLE [dbo].[CompanyDetails]

ALTER COLUMN ClientName VARCHAR(35) COLLATE Latin1_General_CI_AS