/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 vote280 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote293 views1 answer
Sql out file formate
SQL
0 vote277 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
5 votes278 views1 answer
Alter table add comment oracle
SQL
0 vote272 views1 answer
Sqlite update where exists
SQL
0 vote306 views1 answer
Create a plsql object
SQL
7 votes284 views3 answers
Python and mysql connectivity
SQL
5 votes275 views1 answer
Sql use database
SQL
0 vote297 views1 answer
Select true if exists on another table or false sqlserver
SQL
1 vote302 views1 answer
Group_concat order by
SQL