/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 vote358 views1 answer
Convert varchar to int in sqlite
SQL
1 vote387 views1 answer
Mysql select row max date
SQL
0 vote340 views1 answer
Mysql identified by syntax error
SQL
21 votes390 views5 answers
Oracle all tables
SQL
0 vote331 views1 answer
Save single sql query result boolean spring boot
SQL
1 vote303 views1 answer
Postgres grant read only access to database
SQL
2 votes342 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote355 views1 answer
<sql:datasource var="Snapsho"
SQL
1 vote369 views1 answer
Mysql strict_trans_tables
SQL
1 vote365 views1 answer
Sql where last 12 months
SQL