way2onlineLearning

 Create Table way.orders ( Order_num int, order_date date, Customer_id int, Rep int, MFR varchar(15), Product varchar(15), qty int, Amount money primary key (Order_num) )

 USE [SqlKiPathashala] GO INSERT INTO [dbo].[Products]            ([MFR_ID]            ,[Product_id]            ,[Describtion]            ,[price]            ,[QTY_IN_HAND])      VALUES            ('REI'            ,1            ,'Ratchet link'            ,579            ,210) GO

 Step 1: Create A Schema use SqlKiPathashala Create Schema Way; Step 2: CREATE TABLE Way.Products ( MFR_ID varchar(15), Product_id int not null, Describtion text, price money, QTY_IN_HAND int Primary Key (Product_id))