/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 vote217 views1 answer
Sql server pivot rows to columns
SQL
0 vote286 views1 answer
Run mysql xampp shell
SQL
0 vote195 views1 answer
Mysql command prompt date insert format
SQL
0 vote181 views1 answer
How to connect postgresql database with java
SQL
0 vote234 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote218 views1 answer
Flask sqlalchemy session delete
SQL
1 vote191 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
0 vote274 views2 answers
Disadvantages of stored procedures sql
SQL
-1 vote191 views2 answers
How to display top 50 rows?
SQL
1 vote262 views1 answer
Mysql sort by date column
SQL