表名：ZL_UserRecei












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是  否  
2ReceivNamenvarchar500   是 收货人姓名
3Streetnvarchar10000   是 街道
4Zipcodenvarchar500   是 邮政编码
5phonenvarchar500   是 电话号码
6MobileNumnvarchar500   是 手机号码
7isDefaultint40   是 是否默认:0为是,1为否
8UserIDint40   是 用户ID
9Provincesnvarchar500   是 省市
10Emailnvarchar500   是 电子邮箱

简要说明：

用户地址表

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
) ON [PRIMARY]

GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'收货人姓名' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserRecei', @level2type=N'COLUMN',@level2name=N'ReceivName'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'街道' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserRecei', @level2type=N'COLUMN',@level2name=N'Street'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'邮政编码' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserRecei', @level2type=N'COLUMN',@level2name=N'Zipcode'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'电话号码' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserRecei', @level2type=N'COLUMN',@level2name=N'phone'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'手机号码' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserRecei', @level2type=N'COLUMN',@level2name=N'MobileNum'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'是否默认:0为是,1为否' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserRecei', @level2type=N'COLUMN',@level2name=N'isDefault'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'用户ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserRecei', @level2type=N'COLUMN',@level2name=N'UserID'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'省市' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserRecei', @level2type=N'COLUMN',@level2name=N'Provinces'

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

detele from ZL_UserRecei

--注意：将删除整个表

drop table ZL_UserRecei

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

TRUNCATE table ZL_UserRecei