CREATE TABLE [dbo].[TreeViewTable] (
	[NodeId] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ParentId] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[NodeName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Url] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[TreeViewTable] WITH NOCHECK ADD 
	CONSTRAINT [PK_TreeViewTable] PRIMARY KEY  CLUSTERED 
	(
		[NodeId]
	)  ON [PRIMARY] 
GO

