表名:ZL_Pub_Excel

简要说明:

ZL_Pub_Excel

GO

CREATE TABLE [dbo].[ZL_Pub_Excel] (

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

[TableName] [nvarchar]  (50) NULL,

[CNames] [ntext]  NULL,

[Fields] [ntext]  NULL,

[UserID] [int]  NULL,

[CreateTime] [datetime]  NULL)

ALTER TABLE [ZL_Pub_Excel] WITH NOCHECK ADD  CONSTRAINT [PK_ZL_Pub_Excel] PRIMARY KEY  NONCLUSTERED ( [ID] )


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

detele from ZL_Pub_Excel

--注意:将删除整个表

drop table ZL_Pub_Excel

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

TRUNCATE table ZL_Pub_Excel