/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 vote324 views1 answer
Rabbitmq service not starting
SQL
0 vote338 views1 answer
Alter owner in PostgreSQL
SQL
20 votes384 views4 answers
How to find average in sql
SQL
0 vote333 views1 answer
Truncate a table then insert data
SQL
0 vote345 views1 answer
Sql get highest date from 3 tabels
SQL
1 vote377 views2 answers
Mysql add column tinyint default 0
SQL
0 vote346 views2 answers
How do I install microsoft SQL on my Mac?
SQL
21 votes333 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote333 views1 answer
Postgres sql alter table delete row
SQL
0 vote350 views1 answer
Mysql calculated column
SQL