cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

Is there a way to extract table DDL from any version of SQL Anywhere. For example, SQL Server has an assembly you can call to get pretty much any information from the database, including DDL for DB objects.

Thanks,

Brad

View Entire Topic
Breck_Carter
Participant

Brad: Ralph's fresh answer prompted me to take another look and read your comments. No, there isn't any facility like what you want, and yes, it is sorely needed. I am personally embarrassed at how difficult it's been over the years to keep Foxhound's schema display up to date with respect to all changes, and I have profound respect for the author(s) of dbunload. I'm guessing you're trying to do the same thing. Suggestion: Describe exactly what you want, and why (make a business case), and post a new question here with the Title "Product suggestion: etcetera".

Breck_Carter
Participant
0 Likes

If memory serves (it often doesn't) the ANSI spec has something to say on this subject... the ANSI standard is like a baseball bat, most useful when you want to hit something with it.