/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 vote149 views2 answers
Postgresql get last 10 records
SQL
0 vote162 views1 answer
What does the -p flag do in mysql cli
SQL
11 votes146 views1 answer
Sql query to find duplicates in column
SQL
0 vote167 views1 answer
Sql date time query find
SQL
0 vote132 views1 answer
Oracle list chain steps
SQL
4 votes178 views6 answers
Select sql
SQL
0 vote145 views1 answer
Groupby sort sql hive
SQL
0 vote149 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
1 vote170 views1 answer
How to show index type in postgresql
SQL
0 vote138 views1 answer
Get who is hired in specific month in sql
SQL