/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 vote290 views2 answers
PostgreSQL having
SQL
7 votes327 views2 answers
How to create index mysql
SQL
0 vote320 views1 answer
Drop view in mysql
SQL
-1 vote278 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote282 views1 answer
Datagrip go to line
SQL
2 votes300 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
0 vote291 views1 answer
Sql server select value large text
SQL
0 vote292 views1 answer
Create database like
SQL
0 vote334 views1 answer
Pagination with row_number
SQL
5 votes299 views1 answer
Sysdate in oracle sql
SQL