/SQL/Sql alter table add column if exists

Sql alter table add column if exists

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;

Source: tableplus.com

Similar codes

1 vote204 views1 answer
Postgres convert exisiting column to text
SQL
10 votes200 views1 answer
Dba_dependencies
SQL
0 vote202 views1 answer
Mssql check if date is greater than today
SQL
7 votes224 views2 answers
MySQL IF without else
SQL
0 vote187 views1 answer
Sql where time stamp is in between
SQL
0 vote198 views1 answer
Sql get month from date
SQL
1 vote205 views1 answer
T-sql disable system versioning
SQL
1 vote206 views1 answer
Sql server datetime vs datetime2
SQL
0 vote211 views1 answer
Get schema of table sql
SQL
0 vote191 views1 answer
Sql cross apply vs join
SQL