Answers for "add column sql if not exists"

SQL
-1

add column if not exists

ALTER TABLE test ADD COLUMN IF NOT EXISTS column_a VARCHAR(255);
ALTER TABLE test MODIFY IF EXISTS column_a VARCHAR(255);
Posted by: Guest on April-15-2021
0

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;
Posted by: Guest on May-07-2021

Code answers related to "add column sql if not exists"

Code answers related to "SQL"

Browse Popular Code Answers by Language