Results 1 to 5 of 5

Thread: Create Table

  1. #1
    Join Date
    Apr 2007
    Posts
    6

    Unanswered: Create Table

    I have created a table already but I want to create another table inside it. Is it even possible?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You can't create tables within tables. You should create subtables with foreign key references to the primary key of the parent table instead.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    As blindman said, with the SQL Standards currently in use, you cannot create a table within another table. I've been told that the new SQL:2006 standard (which no database engine yet implements afaik) describes a new feature which accomplishes this task. Unfortunately, I've had to little time to study the SQL:2006 standard so I don't have any details.
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Do you get copies of the standard roac?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    Currently Google is my friend. But I will have my own copies, yes. They can be bought from http://webstore.ansi.org . As many of the upoming standards are drafts, they have a bit nicer price, $30.
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

Posting Permissions

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