Answers for "how to check if a column exsists in your database and if not how to add it, SQL"

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

Code answers related to "how to check if a column exsists in your database and if not how to add it, SQL"