/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 vote194 views1 answer
Condition in orderby mysql
SQL
4 votes184 views1 answer
Sql group by year
SQL
0 vote218 views1 answer
Pl sql turn off variable substitution
SQL
0 vote218 views1 answer
Mysql persistence.xml
SQL
0 vote243 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote159 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
4 votes206 views1 answer
Sql query to make a existing column auto increment
SQL
21 votes199 views1 answer
Cheatsheet for sql
SQL
0 vote202 views1 answer
Get the next column of a table in mysql
SQL
6 votes191 views4 answers
Sqlite drop table
SQL