Breaking News: Grepper is joining You.com. Read the official announcement!

How to check and add a column if it doesn't exist

Add Answer

Splendid Stork answered on September 7, 2022 Popularity 9/10 Helpfulness 5/10

answer How to check and add a column if it doesn't exist

related add column in sql if not exists

related Adding column if not exist

related Add column if not exists

How to check and add a column if it doesn't exist

Comment

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;

Popularity 9/10 Helpfulness 5/10 Language sql

Source: tableplus.com

Tags: add sql

Link to this answer
Share Copy Link

Contributed on Sep 07 2022

Splendid Stork

0 Answers Avg Quality 2/10

Closely Related Answers

add column in sql if not exists

Comment

-- Checking if the column already exists
IF NOT EXISTS (
    SELECT *
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'your_table_name'
        AND COLUMN_NAME = 'your_column_name'
)
BEGIN
    -- Adding the column
    ALTER TABLE your_table_name
    ADD your_column_name datatype;
END;

Popularity 7/10 Helpfulness 6/10 Language sql

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

Adding column if not exist

Comment

SELECT 
    IF(count(*) = 1, 'Exist','Not Exist') AS result
FROM
    information_schema.columns
WHERE
    table_schema = 'classicmodels'
        AND table_name = 'vendors'
        AND column_name = 'phone';
Code language: SQL (Structured Query Language) (sql)

Popularity 5/10 Helpfulness 1/10 Language sql

Source: www.mysqltutorial.org

Tags: sql

Link to this answer
Share Copy Link

Contributed on Sep 29 2023

Yellowed Yak

0 Answers Avg Quality 2/10

Add column if not exists

Comment

DELIMITER //

CREATE PROCEDURE AddColumnIfNotExists()
BEGIN
    DECLARE CONTINUE HANDLER FOR 1060 -- Error code for duplicate column name
        BEGIN
            -- Column already exists; do nothing
        END;

    -- Check if the column exists
    SELECT COUNT(*)
    INTO @column_exists
    FROM information_schema.columns
    WHERE table_name = 'enter-name-here' AND column_name = 'enter-name-here';

    -- If the column does not exist, add it
    IF @column_exists = 0 THEN
        ALTER TABLE `enter-database-name`.`enter-table-name`
        ADD COLUMN `enter-column-name` VARCHAR(255) NULL DEFAULT NULL AFTER `enter-column-name`;
    END IF;
END;
//

Popularity 7/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql not-exists add

Link to this answer
Share Copy Link

Contributed on Sep 29 2023

Yellowed Yak

0 Answers Avg Quality 2/10

How to check and add a column if it doesn't exist

Contents

More Related Answers

How to check and add a column if it doesn't exist

Closely Related Answers

add column in sql if not exists

Adding column if not exist

Add column if not exists

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.