/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 votes172 views4 answers
Sql server pagination
SQL
1 vote129 views1 answer
Sql where last 12 months
SQL
0 vote143 views1 answer
Trigger stock phpmyadmin output message
SQL
1 vote137 views1 answer
How to check the mysql version mac
SQL
1 vote142 views1 answer
Float precision in psql
SQL
0 vote145 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote133 views1 answer
What is delimiter in mysql
SQL
0 vote133 views1 answer
Sql revert migration
SQL
4 votes141 views1 answer
Id increment ms sql server
SQL
0 vote138 views1 answer
Kill slow queries mysql
SQL

Share