/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 vote183 views1 answer
Narural join
SQL
1 vote187 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
1 vote184 views1 answer
Sql oracle update multiple rows
SQL
0 vote193 views1 answer
Commit transaction sql
SQL
1 vote200 views1 answer
Postgresql reset serial counter after deleting content
SQL
1 vote198 views1 answer
How to update date add hours in postgresql
SQL
0 vote208 views1 answer
Sql get count without group by
SQL
0 vote190 views1 answer
Access mysql database docker container shell
SQL
0 vote207 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote203 views1 answer
Get yesterday date ISO in psql
SQL