/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

7 votes115 views3 answers
Sql set
SQL
-1 vote96 views1 answer
How to format tables in sqlplus
SQL
1 vote102 views1 answer
Update and replace mysql
SQL
0 vote105 views1 answer
Mysql bash execute sql file
SQL
2 votes105 views1 answer
Set column to not null mysql
SQL
0 vote96 views1 answer
Docker export psql sql
SQL
11 votes108 views1 answer
How to get ddl for materialized view
SQL
8 votes97 views1 answer
How to remove tables from postgresql
SQL
0 vote115 views2 answers
Postgresql variable in query
SQL
0 vote100 views1 answer
Array aggre distinct postgres
SQL

Share