Delete, Drop, Truncate, Shrink, Giga

Delete, Drop, Truncate, Shrink, Giga

https://giga.chat/link/gcswkbvWef

USE Shop

GO

BEGIN TRANSACTION;

DROP TABLE IF EXISTS dbo.OrderDetails;

DROP TABLE IF EXISTS dbo.Orders;

DROP TABLE IF EXISTS dbo.Products;

DROP TABLE IF EXISTS dbo.Users;

COMMIT TRANSACTION;

GO

BEGIN TRANSACTION;

DROP PROCEDURE IF EXISTS dbo.AddProduct;

DROP PROCEDURE IF EXISTS dbo.ProcessOrderDetail;

DROP PROCEDURE IF EXISTS dbo.AddItemToOrderByName;

DROP PROCEDURE IF EXISTS dbo.GetUserReport;

COMMIT TRANSACTION;

GO