/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 vote192 views1 answer
Equi joins in oracle
SQL
0 vote185 views1 answer
Sql remove last x char
SQL
0 vote206 views1 answer
Create mysql pool connection python flask
SQL
1 vote226 views3 answers
How to update column name in psql
SQL
2 votes189 views2 answers
Change varchar length mysql
SQL
0 vote193 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote188 views1 answer
C# datetime to sql server datetime
SQL
0 vote191 views1 answer
Longtext sql
SQL
1 vote381 views2 answers
Sql unique rows
SQL
0 vote192 views1 answer
Table or view does not exist
SQL