AspNetTree

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_Tree]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[t_Tree] GO CREATE TABLE [dbo].[t_Tree] ( [Id] [int] IDENTITY (1, 1) NOT NULL , [Tree_Id] [int] NULL , [Parent_Id] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [NodeName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Location] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [Http_View] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [Http_Edit] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[t_Tree] WITH NOCHECK ADD CONSTRAINT [PK_t_Public_SmallClass] PRIMARY KEY CLUSTERED ( [Id] ) ON [PRIMARY] GO