/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

2 votes270 views1 answer
Add 2 hours to current time in MySQL
SQL
0 vote269 views1 answer
Groupby error in mysql
SQL
12 votes266 views1 answer
Docker mysql random root password
SQL
0 vote274 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
0 vote266 views1 answer
Sauvegarde complète my sql
SQL
0 vote275 views1 answer
Select even number id data from table
SQL
0 vote303 views2 answers
Oracle chain rules
SQL
1 vote271 views1 answer
Multiple count in sql
SQL
0 vote266 views2 answers
Postgresql get last day of month
SQL
0 vote268 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL