1 Replies - 634 Views - Last Post: 06 July 2012 - 02:47 AM Rate Topic: -----

#1 rony001  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 06-July 12

is it possible to create tables from the list of items of a column?

Posted 06 July 2012 - 12:58 AM

Is there any way in SQL to create tables from the list of item names from an existing table ? for example i have this table
table1
item name quantity cost
item1 2 20
item2 3 30

out put tables
item1(table)
item name quantity cost
item1 2 20

item2(table)
item name quantity cost
item2 3 30

any bit of info would be helpful. thanks in advance
Is This A Good Question/Topic? 0
  • +

Replies To: is it possible to create tables from the list of items of a column?

#2 Atli  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 3730
  • View blog
  • Posts: 6,017
  • Joined: 08-June 10

Re: is it possible to create tables from the list of items of a column?

Posted 06 July 2012 - 02:47 AM

It's possible, yes, but the more important question is: Why do you want to do this? You should never have to generate tables based on data. The table structure should be fixed, and all data should go into the existing tables, not become new tables.
Was This Post Helpful? 2
  • +
  • -

Page 1 of 1