xxxxxxxxxx
IF NOT EXISTS (
SELECT
*
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'table_name' AND COLUMN_NAME = 'col_name')
BEGIN
ALTER TABLE table_name
ADD col_name data_type NULL
END;
xxxxxxxxxx
-- Checking if the column already exists
IF NOT EXISTS (
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'your_table_name'
AND COLUMN_NAME = 'your_column_name'
)
BEGIN
-- Adding the column
ALTER TABLE your_table_name
ADD your_column_name datatype;
END;