' Listing 3: NewProducts table in the Production schema

CREATE TABLE Production.NewProducts
(
   ProdName NVARCHAR(50) NOT NULL,
   ProdNumber NVARCHAR(25) NOT NULL,
   ProdCategory CHAR(4) NOT NULL,
   ProdSize CHAR(2) NULL,
   ProdType VARCHAR(10) NOT NULL
)