AnsweredAssumed Answered

Can I script a table name change?

Question asked by whardy7 on Nov 19, 2015
Latest reply on Nov 22, 2015 by whardy7

I need to change a table name once it has been created. I think there are other ways around it, but I'm looking for ideas. Here's my situation...

 

I'm querying several online book databases that each return a JSON file. A handy MonkeyBread plugin creates tables/fields from the JSON. The plugin does what it's supposed to basically. But, one of the JSONs (World Catalog system) constructs their JSON differently than all the others, which results in a table name of that book's ISBN number. The table name ends up being something like ISBN:3876098761. Each query obviously results in a different table name. Once I create the tables, I consolidate them into my own Library database, then delete the record. The next query it creates another table with a whole different name. There are several other tables that rely upon this table (it becomes the parent/child to about 12 different relationships).

 

Any ideas? I can clarify if it doesn't make sense.

 

Wayne

Outcomes