Hi - I'm using
show in xml table
to faciliate a system integration.
Is there anyway to do the reverse - i.e. to turn xml into a create table statement?
Hi Jaime,
I don't believe there is. Teradata basically requires an SQL statement (i.e. plain text) in order to create a table.
You could probably load an XML document into a table, shred it to extract the parts, building the components of a 'create table' statement and then execute that. After the load i think this could be done using a stored procedure.
Cheers,
Dave
Makes sense. If anyone has developed such a stored procedure, and wishes to share it, I'd be interested.
There is some good information that you can find from the below URL
https://downloads.teradata.com/extensibility/articles/a-quick-tour-of-the-xml-type