/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

0 vote343 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
1 vote425 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote372 views1 answer
Selecting Multiple Columns in SQL
SQL
8 votes373 views3 answers
Postgres connection string
SQL
1 vote360 views1 answer
Add multiple row table pl sql
SQL
1 vote349 views1 answer
Mysql workbench in ubuntu 14.04
SQL
26 votes336 views6 answers
Modify column name in sql
SQL
3 votes388 views3 answers
Mysql declare variable
SQL
0 vote352 views1 answer
Sql check for null and empty string
SQL
3 votes340 views1 answer
Select table column in sql
SQL