/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

6 votes126 views3 answers
Oracle all dates between two dates
SQL
6 votes131 views2 answers
Postgresql restore from dump
SQL
20 votes126 views3 answers
SQL query rename table
SQL
3 votes131 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote125 views2 answers
Check mysql timezone
SQL
0 vote164 views1 answer
Store case result sql
SQL
0 vote128 views1 answer
Mysql multiple primary keys
SQL
3 votes136 views2 answers
How to force truncate a table in mysql
SQL
4 votes131 views2 answers
Postgre sql create table
SQL
0 vote128 views1 answer
Sqlplus change user
SQL

Share