mytest_product_create.sql

/*==============================================
*                                              *
*         create table product                 *
*                                              *
==============================================*/


USE mytest; -- you must have created the database mytest


IF OBJECT_ID ('product', 'U') IS NOT NULL
    BEGIN
    PRINT 'The table product already exists. Delete it.'
    RETURN
    END


-- =========== create table product ===========


-- create table product

CREATE TABLE product (
    prodid    INT            NOT NULL PRIMARY KEY,
    pname     VARCHAR(100)   NOT NULL,
    unit      VARCHAR(20)    NULL,
    price     NUMERIC(12,2)  NULL
)