/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 vote349 views1 answer
Sqlite referential integrity
SQL
1 vote349 views1 answer
Loading local data is disabled mysql
SQL
2 votes358 views3 answers
3 days back in sql server
SQL
0 vote426 views1 answer
Oracle convert int to date
SQL
0 vote364 views1 answer
Mysql terminal run sql file
SQL
3 votes339 views1 answer
Oracle apex message quit website
SQL
1 vote366 views1 answer
Tsql create unique index composite
SQL
3 votes350 views1 answer
Sql multi column index performance
SQL
0 vote338 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
3 votes432 views1 answer
Where id is in list sql
SQL