用
CREATE TABLE [dbo].[tablename] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
parent_id int IDENTITY (1, 1) NOT NULL ,
catalog_name char (50)
)
CREATE TABLE [dbo].[tablename] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
parent_id int IDENTITY (1, 1) NOT NULL ,
catalog_name char (50)
)
[id] int identity(1,1),
parent_id int REFERENCES for_test([id]),
catalog_name varchar(100),
PRIMARY KEY([id])
)
go