/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 vote253 views1 answer
Query to insert image
SQL
0 vote260 views1 answer
Import sql inside hide sql
SQL
21 votes280 views1 answer
Cheatsheet for sql
SQL
2 votes261 views1 answer
Codeigniter print last sql query
SQL
0 vote292 views1 answer
Pgadmin save data greyed out
SQL
0 vote260 views1 answer
Sql select merge multiple values
SQL
1 vote273 views1 answer
Sql server list locks
SQL
0 vote294 views1 answer
Min:sec datediff mssql
SQL
0 vote276 views1 answer
Can we rollback in sql
SQL
0 vote301 views3 answers
Characters found after end of sql statement
SQL