/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

31 votes233 views4 answers
Mysql grant execute
SQL
1 vote184 views1 answer
Mysql select and count left join
SQL
1 vote199 views1 answer
Oracle plan hash value
SQL
6 votes164 views3 answers
Oracle all dates between two dates
SQL
3 votes161 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote172 views1 answer
Hibernate with springboot mysql
SQL
6 votes169 views2 answers
Drop foreign key
SQL
0 vote119 views2 answers
Denormalization in sql
SQL
5 votes125 views1 answer
Postgres upsert
SQL
2 votes255 views1 answer
Db.relationship sqlalchemy flask
SQL