Search results
The DROP COLUMN command is used to delete a column in an existing table. The following SQL deletes the "ContactName" column from the "Customers" table:
If you’d like to remove a column from a table, use this statement. First, write ALTER TABLE, followed by the name of the table you want to change (in our example, product ). Next add the DROP COLUMN clause, followed by the name of the column you want to remove (in our example, description ).
SQL - Delete Columns from a Table. The ALTER command is a DDL command to modify the structure of existing tables in the database by adding, modifying, renaming, or dropping columns and constraints. Use the DROP keyword to delete one or more columns from a table.
Sometimes, you may want to drop one or more unused column from an existing table. To do so, you use the ALTER TABLE as follows: ALTER TABLE table_name. DROP COLUMN column_name1, [ DROP COLUMN column_name2]; Code language: SQL (Structured Query Language) (sql) In this syntax:
Jun 28, 2023 · Utilizing the SQL ALTER TABLE statement, you can effortlessly remove a column from your database schema. Throughout this article, we’ll provide you with step-by-step instructions on how to drop a column in SQL, ensuring an optimized and clean table structure in your database.
Sep 6, 2019 · September 6, 2019 by Rajendra Gupta. In this article, we will explore the process of SQL Delete column from an existing table. We will also understand the impact of removing a column with defined constraints and objects on it.
