/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

-1 vote362 views4 answers
Sql view postgresql
SQL
8 votes322 views1 answer
Alter tablespace add datafile autoextend
SQL
1 vote379 views1 answer
Import sql file from laravel
SQL
1 vote350 views1 answer
Sql server delete top 1000
SQL
0 vote318 views1 answer
Mysql order by where condition sub query
SQL
0 vote326 views1 answer
Make a socket server to detect changes in mysql
SQL
9 votes303 views1 answer
Identity insert on sql server
SQL
7 votes337 views4 answers
What is my mysql version
SQL
0 vote359 views1 answer
SQL server datetime compare
SQL
1 vote272 views1 answer
Prevent duplicate rows in postgres
SQL