表名：ZL_UserRecei

简要说明：

ZL_UserRecei

GO

CREATE TABLE [dbo].[ZL_UserRecei](

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

[ReceivName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,

[Street] [nvarchar](1000) COLLATE Chinese_PRC_CI_AS NULL,

[Zipcode] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,

[phone] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,

[MobileNum] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,

[isDefault] [int] NULL,

[UserID] [int] NULL,

[Provinces] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,

[Email] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL

) 


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

detele from ZL_UserRecei

--注意：将删除整个表

drop table ZL_UserRecei

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

TRUNCATE table ZL_UserRecei