locked
Table Inheritance RRS feed

  • Question

  • Hi, I am running SQL SERVER 2005 Enterprise Edition under Windows 2003 server. I would like to use table hierarchies (inheritance) in SQL 2k5 just as we do it in informix,PosgresSQL and other databases. Can we do the same in SQL 2k5 also? If yes, then  how?

    Thanks

    Tuesday, March 7, 2006 6:10 PM

Answers

  • I may not understand your question - if by "table hierarchies" you mean tree-like information, you can find out more here:

    http://support.microsoft.com/kb/248915

    But if you mean "inheritance" to say "cascades", then you can learn more here:

     http://www.mssqlcity.com/Articles/General/using_constraints.htm

    I think you mean the inheritance that DB2 does, which allows a single table to propagate its properties (such as constraints and so on) down to "children" tables. If that's the case, then in a SQL Server environment this is normally done in managed code, not at the table-level.

    • Marked as answer by techgeek12345 Sunday, August 1, 2010 9:55 PM
    Monday, February 26, 2007 3:27 PM