/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 vote189 views1 answer
Mysql extract days
SQL
1 vote163 views1 answer
Import local sql into remote mysql
SQL
0 vote168 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote169 views1 answer
How to find columns with null values in sql
SQL
0 vote166 views2 answers
Sql select inside select
SQL
12 votes162 views2 answers
Delete all data in neo4j
SQL
10 votes175 views1 answer
Query to find object dependencies in oracle
SQL
0 vote166 views1 answer
Can't connect to postgresql mac os
SQL
1 vote185 views2 answers
Logical operators in sql
SQL
0 vote154 views2 answers
Influxdb delete measurement based on date
SQL