/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 vote120 views1 answer
Sql server remove primary key without dropping table
SQL
0 vote113 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote124 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote97 views2 answers
How to start postgresql laravel
SQL
0 vote110 views1 answer
Pl sql round
SQL
0 vote112 views1 answer
Odd record sql query
SQL
3 votes109 views3 answers
Sql last week
SQL
3 votes109 views2 answers
Oracle for loop
SQL
7 votes113 views1 answer
Oracle pagination query offset
SQL
0 vote106 views1 answer
Monthly Birthday SQL Query
SQL