/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 vote103 views1 answer
Mysql alter decimal precision
SQL
1 vote101 views2 answers
How to check username in mysql command line
SQL
0 vote107 views1 answer
Ksql quickstart docker
SQL
4 votes143 views1 answer
Rename stored procedure in sql server
SQL
6 votes108 views1 answer
Oracle pl sql source
SQL
1 vote139 views1 answer
Wordpress change url phpmyadmin
SQL
19 votes100 views2 answers
Mysql add column after another
SQL
5 votes103 views1 answer
Alter table add comment oracle
SQL
7 votes109 views1 answer
Buy forge mods server hosting
SQL
1 vote98 views1 answer
Pv mysql import
SQL