/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 vote160 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
3 votes129 views1 answer
Delete all content in table mysql
SQL
0 vote135 views1 answer
Sql server datetime to string
SQL
0 vote233 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
5 votes145 views3 answers
Bash: mysql: command not found
SQL
0 vote153 views1 answer
Running percentage of total postgres
SQL
0 vote150 views1 answer
How to find total working hour in sql
SQL
0 vote139 views1 answer
How to export only procedures mysql
SQL
0 vote139 views1 answer
My sql data file extention
SQL
0 vote143 views1 answer
Show all mongodb
SQL