/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 vote174 views1 answer
Sql insert from excel
SQL
0 vote176 views1 answer
Inner joint
SQL
0 vote148 views1 answer
How to set field to null in sql
SQL
0 vote195 views1 answer
Oracle running queries
SQL
3 votes199 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
3 votes188 views1 answer
Null sql
SQL
0 vote175 views1 answer
Sql server beginning of month
SQL
0 vote176 views1 answer
Mysql insert into select with recursive
SQL
2 votes183 views2 answers
Mysql on duplicate key update get value from values
SQL
2 votes197 views2 answers
Postgres timestamp to datetime
SQL