SQL Server Statement Creation table

Use Uer--the database in which the carton is currently operating
Go
--Create a Product category table
CREATE TABLE Commoditysort (
SortId int IDENTITY (+) not NULL,--class ID
Sortname varchar () not NULL--category name
)
Go

--Commodity Information table

Use Uer
Go
CREATE TABLE Commodityinfo (
Commodityid int IDENTITY (a) not NULL,--Product ID
Sortid int not NULL,--foreign key, category of commodity
Commodityname varchar () not NULL,--product name
Picture Image,--Product image
Inprice float not NULL,--purchase price of commodity
Outprice float not NULL,--retail price of commodity
Amount int NOT null--inventory quantity of goods
)
Go

SQL Server Statement Creation table