/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

25 votes139 views4 answers
Sqlserver add column
SQL
0 vote135 views1 answer
Sparql list all graphs
SQL
1 vote125 views1 answer
Login to database mysql terminal
SQL
38 votes208 views6 answers
Ubuntu install mysql client
SQL
0 vote134 views1 answer
Insert overwrite table in mysql in nifi
SQL
1 vote163 views1 answer
Mysql default port
SQL
0 vote96 views1 answer
Prevent duplicate rows in postgres
SQL
5 votes86 views1 answer
Mongodb vs
SQL
47 votes206 views6 answers
Add column mysql
SQL
3 votes120 views1 answer
Oracle list user grants
SQL