Question: Write SELECT INTO statement to create two test tables named VendorCopy and InvoiceCopy that are complete copies of the Vendors and Invoices tables. If VendorCopy
Write SELECT INTO statement to create two test tables named VendorCopy and InvoiceCopy that are complete copies of the Vendors and Invoices tables. If VendorCopy and InvoiceCopy already exist, first run the following statements to DROP those two tables. IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[VendorCopy]') AND TYPE IN (N'U')) DROP TABLE [dbo].[VendorCopy] IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InvoiceCopy]') AND TYPE IN (N'U')) DROP TABLE [dbo].[InvoiceCopy]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
