Re: CREATE TABLE DDL from DBI Statement

by dokkeldepper (Friar)

on Jul 22, 2008 at 05:58 UTC ( [id://699210]=note: print w/replies, xml )

Need Help??

"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]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://699210]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others pondering the Monastery: (3)

As of 2024-04-18 19:04 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found