Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql drop multiple columns if exists

-- SQL Server
ALTER TABLE t DROP COLUMN IF EXISTS col1, 
                   COLUMN IF EXISTS col2;
Comment

drop multiple columns in sql

ALTER TABLE TableName
    DROP COLUMN Column1,
    DROP COLUMN Column2;
Comment

PREVIOUS NEXT
Code Example
Sql :: condition in count sql 
Sql :: sql count 
Sql :: mysql replace remove html tag 
Sql :: list of all table names in sql server databse 
Sql :: oracle select first row order by 
Sql :: oracle remove line breaks 
Sql :: sql pagination oracle 
Sql :: how to drop all tables in sql 
Sql :: create temporal table in sql 
Sql :: sql convert date to string yyyy-mm-dd 
Sql :: postgresql resolv duplicate value violates unique constraint 
Sql :: mysql current time 
Sql :: oracle revoke grant 
Sql :: drop primary key oracle 
Sql :: update and replace mysql 
Sql :: how to select one row in mysql 
Sql :: in mysql workbench contnent not feching 
Sql :: select 2 rows in sql 
Sql :: Cast for print sql 
Sql :: sql convert datetime to year 
Sql :: mariadb json_extract 
Sql :: sqlalchemy update row 
Sql :: get primary key of last inserted record sql server 
Sql :: alter column set not null to null postgres 
Sql :: oracle table free space 
Sql :: mysql multiple order by 
Sql :: mysql remove records 
Sql :: sql currency format 
Sql :: update sqlite 
Sql :: how to find special characters in sql 
ADD CONTENT
Topic
Content
Source link
Name
3+1 =