Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Do nested tables in SQL exist?

    is there any implementation of nested tables in SQL ?

    i have been told by my teacher that i will have to use nested tables in my project and i am using sql server 2008. i have searched the internet but have failed to find any useful info.. i read in a post in a forum that that concept of nested tables does not exist the way it does in oracle ( that is table within a table) but has the concept of primary and foreign key instead ..

    PLEASE TELL ME WHETHER NEST TABLES EXIST IN SQL ?
    AND IF SO PLEASE HELP ME WITH THE CONCEPT ...
    THANKYOU !
    Last edited by its102anu; 03-30-09 at 14:13.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    By SQL you mean SQL Server correct?
    SQL is a declarative language used with relational databases.
    SQL Server is a relational database product.

    If it is SQL Server, I will move this to the SQL Server forum.
    Or another mod will.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Standard SQL has nested table types (AKA structured types). SQL Server 2008 does not.

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    As an aside, it pains me that colleges are teaching topics like nested tables, a feature added to DBMSs like Oracle purely to tick a box in their "object-relational" feature list and of no practical use to anybody. So every year a mass of students emerge from their colleges thinking nested tables are something you should be using in your databases, and if unchecked no doubt introduce them into their employers' databases. *Sigh*.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •