/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 vote293 views1 answer
Match end of string regex sql
SQL
21 votes306 views1 answer
Cheatsheet for sql
SQL
25 votes318 views6 answers
Import database mysql command line
SQL
1 vote302 views1 answer
Get table column names sql ssms
SQL
5 votes308 views2 answers
Get number of columns sql
SQL
18 votes278 views2 answers
Sql inner join
SQL
37 votes296 views3 answers
Duplicate records in sql
SQL
3 votes295 views1 answer
Fk in insert mysql
SQL
10 votes310 views3 answers
Sql select between two dates
SQL
3 votes286 views1 answer
Postgres update column with value from another table
SQL