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?
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.
There is some good information that you can find from the below URL