/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 vote121 views1 answer
Default column value in sql same as another column laravel
SQL
15 votes118 views2 answers
Select where duplicate mysql
SQL
0 vote107 views1 answer
Mysql connection with sqlalchecmy
SQL
0 vote130 views1 answer
Python sqlalchemy connection show server
SQL
2 votes107 views1 answer
Merge two columns in sql oracle
SQL
-1 vote124 views1 answer
How to reset autoincrement in sqlite java
SQL
3 votes130 views2 answers
Sql select data from last week
SQL
0 vote124 views1 answer
Call object contructor and call methods of object
SQL
0 vote114 views1 answer
How to find the most occuring in SQL
SQL
19 votes130 views5 answers
Date between in mysql
SQL