/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 vote136 views1 answer
Drop database using terminal postgres
SQL
3 votes136 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
18 votes116 views4 answers
Foreign key mySql
SQL
-2 votes131 views1 answer
No module named '_sqlite3
SQL
0 vote128 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
1 vote122 views1 answer
Sql how to duplicate a table
SQL
6 votes135 views2 answers
Return columns from table sql
SQL
4 votes231 views6 answers
Laravel jwt
SQL
0 vote125 views1 answer
Oracle list datafiles
SQL
0 vote124 views1 answer
T-SQL Retry (deadlock)
SQL