/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

3 votes410 views1 answer
Sql select second max
SQL
0 vote398 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
0 vote316 views1 answer
Select even number id data from table
SQL
1 vote348 views1 answer
Sql view where tables have same column name combine results
SQL
5 votes305 views2 answers
Mysql drop table cascade
SQL
0 vote310 views1 answer
Grouping by email domain mysql
SQL
0 vote293 views1 answer
Vbscript create ADODB.Connection
SQL
1 vote337 views1 answer
Mysql select from outside
SQL
1 vote299 views2 answers
Oracle replace
SQL
0 vote400 views1 answer
Current month transactions in mysql
SQL