表名：ZL_3DShop

简要说明：

ZL_3DShop

GO

CREATE TABLE [dbo].[ZL_3DShop] (

[ID] [int]  IDENTITY (1, 1)  NOT NULL,

[ShopName] [nvarchar]  (50) NULL,

[ShopImg] [nvarchar]  (100) NULL,

[UserID] [int]  NULL,

[UserName] [nvarchar]  (50) NULL,

[posX] [nvarchar]  (50) NULL,

[posY] [nvarchar]  (50) NULL,

[ShopStatus] [int]  NULL,

[Remind] [nvarchar]  (50) NULL)

ALTER TABLE [ZL_3DShop] WITH NOCHECK ADD  CONSTRAINT [PK_ZL_3DShop] PRIMARY KEY  NONCLUSTERED ( [ID] )


SET IDENTITY_INSERT [ZL_3DShop]


--注意：将清空全表数据

detele from ZL_3DShop

--注意：将删除整个表

drop table ZL_3DShop

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_3DShop