/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 vote310 views1 answer
Delete * from where id = 1;
SQL
0 vote298 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote294 views1 answer
Google cloud sql postgres url example
SQL
2 votes310 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
1 vote292 views1 answer
Search for tables with name postgresql
SQL
0 vote320 views1 answer
Microsoft sql server python connection
SQL
0 vote291 views1 answer
Oracle select invalid views
SQL
3 votes295 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote300 views1 answer
Dapper run sql script with parameters
SQL
1 vote300 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL