CODEWITHSUNDEEP
sqlsql-servert-sqlsql-server-2008hierarchical-data
Rauf
Rauf

Reputation: 12842

hierarchyid SQL Server 2008

I want to store the regional information of a customer, for this, I will create the following tables

  1. Country
  2. State
  3. District

But using hierarchyid in SQL Server 2008, I think I can store the information in a single table called Region. Am I right?

Upvotes: 0

Views: 381

Answers (1)

Magnus
Magnus

Reputation: 46947

If Country, State and District share the same columns than a tree like structure would fit your needs. You could use hierarchyid or just a self referencing foreign key

Upvotes: 2

Related Questions