来自「JAVA下的SQL_System的建立」· 代码 · 共 21 行

USE auser
GO
DROP TABLE  product_Info
GO
CREATE TABLE product_Info
(
Product_ID   smallint,
Product_Name  char(20),
Description  vchar(30),
Price   smallmoney,
Brand_ID brand_type
)
GO
CREATE TABLE brands
(
Brand_ID brand_type,
Brand_Name  vchar(30),
Supplier_ID smallint
)
GO