/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

2 votes352 views1 answer
Q operator in oracle
SQL
0 vote319 views1 answer
Grepper sql workbench download
SQL
-1 vote311 views1 answer
Export mysql table to file
SQL
0 vote327 views1 answer
Sql select most frequent value in column
SQL
10 votes349 views3 answers
Sql select between two dates
SQL
0 vote336 views1 answer
How to reset the database value in SQL server
SQL
1 vote308 views1 answer
Add time to date sql
SQL
-1 vote331 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
0 vote319 views1 answer
Java spring boot connect to sql server
SQL
0 vote356 views1 answer
Contraint default SQL
SQL

Share