表名:ZL_Page_Content












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40   
2Contentntext160   ''黄页内容

简要说明:

自助建站内容表


 CREATE TABLE [dbo].[ZL_Page_Content] (  [ID] [int] IDENTITY (1, 1) NOT NULL , [Content] [ntext] NULL )
 ALTER TABLE [dbo].[ZL_Page_Content] WITH NOCHECK ADD CONSTRAINT [DF_ZL_Page_Content_Content] DEFAULT ('') FOR [Content],CONSTRAINT [PK_ZL_Page_Content] PRIMARY KEY  NONCLUSTERED ( [ID] )

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

detele from ZL_Page_Content

--注意:将删除整个表

drop table ZL_Page_Content

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

TRUNCATE table ZL_Page_Content