【正文】 where id = object_id(39。) and name = 39。 and indid 0 and indid 255) drop index order.content_FKgoif exists (select 1 from sysindexes where id = object_id(39。) and name = 39。 and indid 0 and indid 255) drop index order.destination_FKgoif exists (select 1 from sysindexes where id = object_id(39。) and name = 39。 and indid 0 and indid 255) drop index order.generate_FKgoif exists (select 1 from sysindexes where id = object_id(39。) and name = 39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysindexes where id = object_id(39。) and name = 39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysindexes where id = object_id(39。) and name = 39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysindexes where id = object_id(39。) and name = 39。 and indid 0 and indid 255) drop index user.managment_FKgoif exists (select 1 from sysindexes where id = object_id(39。) and name = 39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table panygoif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table positiongoif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table goodsgoif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table materialgoif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table ordergoif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table purchasinggoif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table supplygoif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table usergoif exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop table warehousego/*==============================================================*//* Table: pany *//*==============================================================*/create table pany ( pany_id1 text not null, pany_name text null, pany_address text null, constraint PK_COMPANY primary key nonclustered (pany_id1))go/*==============================================================*//* Table: position *//*==============================================================*/create table position ( material_id1 text not null, goods_id text not null, constraint PK_COMPOSITION primary key (material_id1, goods_id))go/*==============================================================*//* Index: position_FK *//*==============================================================*/create index position_FK on position (material_id1 ASC)go/*==============================================================*//* Index: position2_F