/SQL/Drop multiple columns in sql

Drop multiple columns in sql

Sql drop multiple columns if exists

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

1

Source: stackoverflow.com

Drop multiple columns in sql

ALTER TABLE TableName
    DROP COLUMN Column1,
    DROP COLUMN Column2;

0

Source: stackoverflow.com

Add bool column in sql

ALTER TABLE person add  [AdminApproved] BIT default 'FALSE';

-1

Source: stackoverflow.com

Similar codes

10 votes297 views2 answers
SQL rounding numbers
SQL
3 votes269 views1 answer
Oracle apex warning message
SQL
1 vote278 views2 answers
Mysql error 1215
SQL
10 votes282 views4 answers
How to alter table name in mysql
SQL
0 vote286 views2 answers
Jsonb
SQL
0 vote305 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
2 votes290 views1 answer
Mysql application.properties spring boot
SQL
0 vote290 views1 answer
Oracle lower in where clause
SQL
2 votes279 views1 answer
Drop sequence
SQL
1 vote278 views1 answer
Get all db sizes in mysql server
SQL

Share