/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 vote211 views1 answer
Postgresql create table with boolean column
SQL
5 votes192 views1 answer
Mongodb vs
SQL
17 votes217 views3 answers
How to change a collumn name in sql
SQL
0 vote223 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote229 views1 answer
Select multiple row from primary key sql
SQL
0 vote234 views1 answer
Mysql 5.7 in centos 7
SQL
2 votes234 views2 answers
Mysql count rows returned
SQL
1 vote195 views1 answer
Sql myisam vs innodb
SQL
0 vote217 views1 answer
Product of a column in mysql
SQL
-1 vote215 views1 answer
Sql add column bit
SQL