5> CREATE TABLE product(
6> product_no CHAR(10) NOT NULL UNIQUE,
7> product_name CHAR(20) NULL,
8> price MONEY NULL)
9> GO
1> ALTER TABLE product
2> ADD CONSTRAINT prim_prod PRIMARY KEY(product_no)
3> GO
1>
2> drop table product;
3> GO