In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Extracting DDL using Alteryx

pereisyd
7 - Meteor

Hi,

 

Is it possible to extract the Sybase DDL for a table (or a set of tables) ? 

 

I'm able to connect using Generic ODBC connection and extract data from the tables.

4 REPLIES 4
apathetichell
19 - Altair

do you mean the ddl of the query - you can try dynamic output in-db and set it for the query.... otherwise you'd need to use an API. Not overly familair with that specific DB syntax so I can't help.

pereisyd
7 - Meteor

No, want to get the table structure like, 

create table xyz 

( id int,

 ...

...

)

caltang
17 - Castor
17 - Castor

This may be of help to you: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Extracting-the-DDL/td-p/338159 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
apathetichell
19 - Altair

Short answer here is probably no.

 

That means it's possible - but not sure if anyone here has the knoweldge on Sybase internals to guide you through it. I'd recommend looking here:

https://stackoverflow.com/questions/34511276/to-extract-ddl-statements-of-a-sybase-database

and other Sybase generic resources since this is 98% a "how do I do it in Sybase" vs a "how do it in Alteryx" question.

Labels
Top Solution Authors