/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

3 votes177 views1 answer
Postgresql where current year
SQL
8 votes206 views2 answers
Safe update mode in mysql
SQL
40 votes279 views4 answers
PostgreSQL add column
SQL
6 votes216 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
1 vote206 views1 answer
How to select rows with no matching entry in another table?
SQL
11 votes210 views2 answers
Safe mode off mysql
SQL
0 vote206 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
1 vote234 views1 answer
Raw query must include primary key
SQL
0 vote210 views1 answer
SqlFunction does not exist
SQL
42 votes279 views6 answers
Install beautifulsoup
SQL