3 Simple Ways to check if Column Exists in the Table - SQL SERVER
How to check if a column exists in a SQL Server table?
Check more details here: https://yarkul.com/check-if-a-column-...
IF NOT EXISTS(SELECT 1 FROM SYS.COLUMNS
WHERE [Name] = N'DateOfBirth' AND Object_ID = Object_ID(N'[YarkulTestDb1].[dbo].[Person]'))
BEGIN
SELECT 'COLUMN DOES NOT EXISTS'
END
--2. INFORMATION_SCHEMA.COLUMNS
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Person' AND COLUMN_NAME = 'DateOfBirth')
BEGIN
SELECT 'COLUMN DOES NOT EXISTS'
END
--3. COL_LENGTH
IF COL_LENGTH('dbo.[Person]', 'DateOfBirth') IS NULL
BEGIN
SELECT 'COLUMN DOES NOT EXISTS'
END
![Spider-Man: The Series | Smallville Style [Season 9]](https://images.videosashka.com/watch/-nwmLcDtb9E)
