/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 vote180 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
0 vote145 views1 answer
Min and max salary and name in sql
SQL
0 vote158 views1 answer
Sql ignore
SQL
0 vote172 views2 answers
Mysql add days to date
SQL
0 vote194 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote150 views1 answer
Will graphql replace sql
SQL
0 vote101 views1 answer
Oracle list all stored procedures
SQL
0 vote418 views1 answer
Create pl/sql stored procedure
SQL
0 vote144 views1 answer
Sql composite key
SQL
0 vote146 views1 answer
Add created and updatedAt fields in mysql
SQL