/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 vote110 views1 answer
Sql select contem uma palavra
SQL
0 vote78 views1 answer
Plsql trigger insert update
SQL
0 vote129 views1 answer
Into operator in sql
SQL
0 vote110 views1 answer
Call function in query sql server
SQL
10 votes130 views2 answers
What is database
SQL
0 vote114 views1 answer
Postgres select except
SQL
1 vote109 views1 answer
Select dba users oracle
SQL
1 vote117 views1 answer
Tsql get beginning of year
SQL
0 vote114 views3 answers
Mysql delete if not in another table
SQL
0 vote115 views1 answer
Forcefully delete a row in mysql which has references
SQL