Re: CREATE TABLE DDL from DBI Statement

"I want to be able to generate the DDL (CREATE TABLE ...) that could hold the returned rows."

Why dont you do a

SELECT * INTO <target> FROM <sourcetable>
[download]

and a

TRUNCATE <target>
[download]

afterwards?

Comment on Re: CREATE TABLE DDL from DBI Statement Select or Download Code

Replies are listed 'Best First'.
Re^2: CREATE TABLE DDL from DBI Statement by whereiskurt (Friar) on Jul 22, 2008 at 13:12 UTC
That would work fine if everything was in the same spot. I'm actually SELECTing records from a remote DB2, and then trying to loosely 'mirror' them locally to a SQLite file. Kurt	[reply]