Answers for "sql drop multiple columns if exists"

SQL
1

sql drop multiple columns if exists

-- SQL Server
ALTER TABLE t DROP COLUMN IF EXISTS col1, 
                   COLUMN IF EXISTS col2;
Posted by: Guest on August-13-2021
0

drop multiple columns in sql

ALTER TABLE TableName
    DROP COLUMN Column1,
    DROP COLUMN Column2;
Posted by: Guest on August-06-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language