/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

27 votes151 views6 answers
Set password mysql
SQL
0 vote135 views1 answer
Sql drop procedure if exists
SQL
1 vote134 views1 answer
Sql run multiple updates in one query
SQL
0 vote134 views1 answer
Query to get all primary keys and foreign key
SQL
15 votes138 views2 answers
Open postgress in terminal mac
SQL
0 vote155 views1 answer
Sql count total by foreign key
SQL
0 vote132 views1 answer
Sql min
SQL
4 votes134 views3 answers
How to describe a table in sqlite3
SQL
0 vote137 views1 answer
Storing RGBA in mysql db
SQL
1 vote135 views1 answer
Mariadb case switch
SQL