Create new table on row insert
Hi All.
I would like to automatically create a new database table when a row is added to one of db tables. For example, if I have a table that stores basic city information (one column being city_name), I would like to automatically create a new table (called city_name) when a new city is added. I would like to do this with a database trigger if possible.
Any help would be greatly appreciated.
Thanks
Rob
I would like to automatically create a new database table when a row is added to one of db tables. For example, if I have a table that stores basic city information (one column being city_name), I would like to automatically create a new table (called city_name) when a new city is added. I would like to do this with a database trigger if possible.
Any help would be greatly appreciated.
Thanks
Rob
