/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 vote195 views1 answer
Postgres docs /copy metacomand
SQL
4 votes151 views2 answers
Sql table
SQL
3 votes158 views1 answer
Start mysql server by terminal in linux
SQL
0 vote117 views2 answers
Delete query sql server
SQL
4 votes298 views2 answers
Sql display today's date
SQL
1 vote154 views1 answer
Postgres first_value in gropby
SQL
1 vote163 views1 answer
Oracle create_program
SQL
0 vote189 views1 answer
Time data type in mysql
SQL
0 vote171 views1 answer
Google cloud sql postgres url example
SQL
0 vote149 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL