/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 vote201 views2 answers
Mysql dump structure only
SQL
10 votes185 views1 answer
User_dependencies
SQL
1 vote194 views1 answer
Best configuration for display table in sqlplus
SQL
-1 vote185 views1 answer
Condition in orderby mysql
SQL
27 votes321 views3 answers
Mysql delete row
SQL
0 vote192 views1 answer
Mysql insert multiple rows based on select
SQL
17 votes251 views4 answers
Mysql remove ubuntu
SQL
8 votes223 views4 answers
Postgresql server restart
SQL
0 vote217 views1 answer
Sql developer sql worksheet not showing
SQL
-1 vote208 views1 answer
Mysql delete duplicate rows except one
SQL