/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 vote172 views1 answer
Sql server 2016 reseed identity
SQL
41 votes204 views6 answers
Alter table add column in SQL Server
SQL
4 votes167 views4 answers
Update select mysql
SQL
0 vote151 views1 answer
Get only first row mysql
SQL
2 votes167 views2 answers
How to get capital letter first in sql
SQL
0 vote191 views1 answer
SQL joins in python
SQL
0 vote187 views2 answers
While mysql
SQL
0 vote164 views1 answer
Sql server current time without date
SQL
2 votes182 views1 answer
Mysql shell insert into
SQL
1 vote219 views1 answer
Oracle create program if not exists
SQL