When a new "site" is created in our database, I'd like it to create a new status database from the template.
I have a table that is a template for other tables to be created. It is blank but is completely set up as far as field sizes, column names, primary keys, data types, etc. Is there a way to effectively "clone" this table under a different name?
For example, if the new site is 6721, I'd like it to make a table called "istatus6721" using the format of "tpl_istatus".
Database is MSACCESS (Not my choice, I swear) and web interface is ASP.