这个想法是这样的(自我引用):
CREATE TABLE FileSystemObject ( ID int not null primary key identity, Name varchar(100) not null, ParentID int null references FileSystemObject(ID), constraint uk_Path UNIQUE (Name, ParentID), IsFolder bit not null)

这个想法是这样的(自我引用):
CREATE TABLE FileSystemObject ( ID int not null primary key identity, Name varchar(100) not null, ParentID int null references FileSystemObject(ID), constraint uk_Path UNIQUE (Name, ParentID), IsFolder bit not null)