/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

1 vote203 views1 answer
Oracle compile schema
SQL
2 votes171 views4 answers
Duplicate record mysql
SQL
0 vote187 views1 answer
How we can perform acid Operations in sql with examples
SQL
2 votes207 views1 answer
Sqlite insert if not exists
SQL
0 vote185 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
-1 vote186 views2 answers
First letter capital in mysql query
SQL
0 vote176 views1 answer
Sql server list user permissions
SQL
2 votes217 views6 answers
In operator in sql
SQL
0 vote176 views1 answer
Update and keep original value sql
SQL
0 vote178 views1 answer
Drop tables from local database postgres pgadmin
SQL

Share