/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 vote186 views1 answer
Limit in access query
SQL
0 vote233 views1 answer
Mysql wsrep ls
SQL
-1 vote192 views3 answers
How to restart mysql in linux
SQL
0 vote238 views1 answer
Mysql row generator
SQL
0 vote174 views1 answer
Cast for print sql
SQL
0 vote138 views1 answer
Postgresql subquery
SQL
1 vote205 views1 answer
Drop colum oracle 18c
SQL
2 votes198 views3 answers
Row number mysql
SQL
1 vote193 views1 answer
Sql headers delphi
SQL
17 votes196 views3 answers
Postgresql version command
SQL