/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 vote139 views1 answer
Psql initialization
SQL
1 vote145 views1 answer
Postgresql contains
SQL
0 vote137 views2 answers
Check mysql timezone
SQL
0 vote140 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
3 votes225 views2 answers
Savepoint in sql
SQL
10 votes135 views1 answer
Create table oracle
SQL
0 vote141 views1 answer
Watch mysql command line
SQL
0 vote143 views1 answer
Get last three characters in mysql column
SQL
6 votes175 views2 answers
WHERE value IS sql
SQL
0 vote146 views1 answer
Sql search all columns of database oracle sql
SQL