How do I store a directory / hierarchy / tree structure in a database?

Asked 2008-09-27T19:59:24.923

How do I store a directory / hierarchy / tree structure in a database? Namely Microsoft SQL Server.

sql-server sql-server-2005 database-design tree-structure

Edit Report

1 Answer

If using Sql Server 2008 is an option: maybe you should check out new hierarchyid data type.

answered 2008-11-17T14:09:03.603