网络电子商店 vs2005 c#

if exists (select 1 from sysobjects where id = object_id('Items') and type = 'U') drop table Items go /*==============================================================*/ /* Table: Items */ /*==============================================================*/ create table Items ( item_id bigint identity(1,1), category_id bigint not null, name varchar(15) not null, description varchar(255) null, quantity int null, base_price float(8) null, small_image_url varchar(255) null, large_image_url varchar(255) null, constraint PK_ITEMS primary key (item_id) ) go alter table Items add constraint FK_ITEMS_CATEGORY__CATEGORI foreign key (category_id) references Categories (category_id) go