Wednesday, November 15, 2017

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