/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 vote216 views1 answer
Rabbitmq service not starting
SQL
1 vote219 views1 answer
Sql sort column by date
SQL
7 votes233 views3 answers
Python and mysql connectivity
SQL
5 votes225 views1 answer
Alter table add comment oracle
SQL
1 vote227 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
0 vote223 views1 answer
Sql not exists
SQL
0 vote237 views1 answer
Mysql date format unix timestamp
SQL
1 vote227 views1 answer
PLS-00225 type
SQL
0 vote220 views4 answers
Best data type to represent money in mysql
SQL
11 votes244 views2 answers
Oracle saurce code
SQL