表名：ZL_C_Photo

简要说明：

ZL_C_Photo

Go

CREATE TABLE [dbo].[ZL_C_Photo] (

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

[author] [nvarchar]  (255) NULL,

[content] [ntext]  NULL,

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

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

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

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


ALTER TABLE [ZL_C_Photo] WITH NOCHECK ADD  CONSTRAINT [PK_ZL_C_Photo] PRIMARY KEY  NONCLUSTERED ( [ID] )

SET IDENTITY_INSERT [ZL_C_Photo]


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

detele from ZL_C_Photo

--注意：将删除整个表

drop table ZL_C_Photo

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

TRUNCATE table ZL_C_Photo