/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 vote323 views2 answers
Setval max id postgresql sequence
SQL
0 vote354 views1 answer
Mysql config address
SQL
0 vote327 views1 answer
Select count postgres double row count > 1
SQL
0 vote369 views1 answer
Sqlalchemy _in array sqlite
SQL
1 vote336 views1 answer
Change old domain to new domain name wordpress
SQL
41 votes427 views6 answers
Alter table add column in SQL Server
SQL
1 vote365 views1 answer
Backup mysql schema only
SQL
1 vote341 views1 answer
Select dba users oracle
SQL
1 vote318 views1 answer
Oracle rolling back transactions
SQL
19 votes344 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL