/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

2 votes228 views1 answer
Sql percentage with % rounded down
SQL
0 vote224 views1 answer
Mysql select all where count more than"
SQL
0 vote230 views1 answer
Oracle list datafiles
SQL
0 vote235 views1 answer
Install postgresql 12 on debian 10
SQL
6 votes232 views1 answer
T-sql test if table exists
SQL
1 vote228 views2 answers
Oracle 18c xe ORA-65096
SQL
1 vote225 views1 answer
Mysql update inner
SQL
1 vote186 views3 answers
Java.sql.sqlexception: access denied for user
SQL
0 vote224 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote202 views1 answer
Sql find leading space
SQL