/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

3 votes320 views1 answer
Sql print all names that start with a given letter
SQL
2 votes303 views1 answer
How to insert string variable into sqlite database
SQL
0 vote299 views1 answer
Where name ends in SQL
SQL
0 vote278 views1 answer
Mysql begin statement
SQL
12 votes321 views4 answers
How to check mysql version ubuntu
SQL
0 vote344 views1 answer
Alternative for LIMIT sql
SQL
21 votes302 views6 answers
Change column in mysql
SQL
1 vote308 views1 answer
How to subtract from the value of a table in sql
SQL
1 vote318 views2 answers
Extract weekday from date in sql
SQL
2 votes320 views1 answer
How to find table table in stored procedure sql server
SQL

Share