show in xml table x

[Jaime]

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?

[DaveWellman]

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

[Jaime]

Makes sense.  If anyone has developed such a stored procedure, and wishes to share it, I'd be interested.

[vkbagare]

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