/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 vote221 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote222 views1 answer
Myswql show full processlist
SQL
6 votes249 views4 answers
Mysql update set
SQL
0 vote344 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
2 votes235 views1 answer
Query any digits record
SQL
3 votes252 views1 answer
Increment integer in table sql
SQL
1 vote211 views1 answer
Sql myisam vs innodb
SQL
0 vote235 views1 answer
Snap craft
SQL
0 vote236 views1 answer
St_buffer mysql
SQL
0 vote291 views1 answer
TSQL Find csv file in folder
SQL