表名:ZL_C_Info

简要说明:

ZL_C_Info

GO

CREATE TABLE [dbo].[ZL_C_Info] (

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

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

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

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

[content] [ntext]  NULL DEFAULT (''),

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

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

[pics] [ntext]  NULL DEFAULT (''),

[synopsis] [ntext]  NULL DEFAULT (''))


ALTER TABLE [ZL_C_Info] WITH NOCHECK ADD  CONSTRAINT [PK_ZL_C_Info] PRIMARY KEY  NONCLUSTERED ( [ID] )

SET IDENTITY_INSERT [ZL_C_Info]


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

detele from ZL_C_Info

--注意:将删除整个表

drop table ZL_C_Info

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

TRUNCATE table ZL_C_Info