Re: How to get table definiton using systables only in you own project?

On Thu, 04 Sep 2003 05:08:11 -0400, Kevin Walsh wrote: > After creating the database and all tables, how to get table definitons using > systables in your project written with ESQL/C?It means that you query the > system tables and produce same table definition with what dbschema produces, > includeing column name,type,default value,extent size,constraints etc. You cannot do this using systables only (like asking how you can drive a car using the steering wheel only) you need at least syscolumns also but maybe sysindexes, sysfragments, sysconstraints, sysreferences, etc. Try telling us what it is you want to accomplish, what's the problem, and perhaps we will have a solution. Everyone, it is not particularly useful to ask us "How do I accomplish the one and only solution I could think of but do not know how to impliment?" Chances are if you cannot figure out how to implement this narrow solution it may not be implementable (is that a word?) It is far better to ask: "I have this problem .... Any solutions?" Art S. Kagel