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 :: Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 
Sql :: oracle set sequence value to max(id) 
Sql :: how to check database engine in mysql 
Sql :: SQL Integer devision 
Sql :: delete a view sql 
Sql :: sql find missing values between two tables 
Sql :: how to convert number to hours and minutes in oracle sql 
Sql :: select item.* as json mysql 
Sql :: generate random data postgresql 
Sql :: postgres convert exisiting column to text 
Sql :: tsql try catch 
Sql :: Odoo Service is not coming up with postgresql read replica (slave) 
Sql :: check message id sql server 
Sql :: mysql bidirectional composite primary key 
Sql :: foreign key oracle 
Sql :: set permanent SET GLOBAL sql_mode ubuntu 
Sql :: laravel migration sql dump 
Sql :: mysql show charset 
Sql :: create policy in sql 
Sql :: sql count columns 
Sql :: how to truncate a table in databse 
Sql :: oracle limit user tablespace 
Sql :: add created and updatedAt fields in mysql 
Sql :: sort by last three charecter in sql 
Sql :: find nth highest salary of an employee 
Sql :: datetime add 2 hours sql 
Sql :: create column sql server 
Sql :: mysqldump: couldn 
Sql :: grant mysql 
Sql :: convert to hexadecimal sql 
ADD CONTENT
Topic
Content
Source link
Name
8+3 =