表名：ZL_C_kdxx

简要说明：

ZL_C_kdxx

GO

CREATE TABLE [dbo].[ZL_C_kdxx] (

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

[fhd] [nvarchar]  (255) NULL DEFAULT (''),

[mdd] [nvarchar]  (255) NULL DEFAULT (''),

[nums] [nvarchar]  (255) NULL DEFAULT (''),

[price] [real]  NULL)

ALTER TABLE [ZL_C_kdxx] WITH NOCHECK ADD  CONSTRAINT [PK_ZL_C_kdxx] PRIMARY KEY  NONCLUSTERED ( [ID] )

SET IDENTITY_INSERT [ZL_C_kdxx] ON

INSERT [ZL_C_kdxx] ([ID],[fhd],[mdd],[nums],[price]) VALUES ( 1,N'江西-南昌-青山湖区',N'深圳-福田区',N'1',10)

SET IDENTITY_INSERT [ZL_C_kdxx] 


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

detele from ZL_C_kdxx

--注意：将删除整个表

drop table ZL_C_kdxx

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

TRUNCATE table ZL_C_kdxx