[rony001]

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

[Atli]

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.