An Engineers Notebook

SQL: Drop Columns and Tables

This SQL code will drop a column from the Products table from the TechShizz database

USE TechShizz
GO

ALTER TABLE Products
    DROP COLUMN Price

This SQL code will drop the Employees, Products and SaleOrders tables from the TechShizz database.

USE TechShizz
GO

DROP TABLE Employees
DROP TABLE Products
DROP TABLE SaleOrders

Leave a Reply

Your email address will not be published.