/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

8 votes200 views1 answer
Mysql restore database
SQL
0 vote187 views1 answer
How to export table data from mysql table in sql format
SQL
15 votes195 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote270 views1 answer
How to check common records in 2 table
SQL
1 vote157 views1 answer
Database run
SQL
0 vote201 views1 answer
Sql server select record with max id
SQL
0 vote183 views1 answer
Mysql drop multiple tables at once
SQL
4 votes192 views1 answer
Create table if not exist in sqlite
SQL
1 vote209 views1 answer
Isnull sql server
SQL
0 vote229 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL

Share