/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 vote262 views1 answer
Java check if something is in mysql table
SQL
1 vote277 views1 answer
Store select query result in variable sql server
SQL
0 vote249 views1 answer
Mysql command line ubuntu
SQL
0 vote250 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
5 votes303 views1 answer
Mysql count lines
SQL
0 vote248 views1 answer
Sql get table last modified time
SQL
0 vote247 views1 answer
Find wordpress version in database
SQL
19 votes265 views5 answers
Mysql between date range
SQL
0 vote251 views1 answer
Oracle gather table statistics
SQL
18 votes266 views3 answers
Mysql add column default value
SQL