Re: Schema Printing Help

How about some variation on the following. You have to do a little interpreting on the coltype and collength but you might be able to build your own table for that. coltype seems to go beyond the simple types and may involve the null or not requirement and collength has some variation within types, but this might be a basis. Good luck select tabname, syscolumns.colname, syscolumns.coltype,syscolumns.collength, syscolumns.colno from systables, syscolumns where systables.tabname[1,3] <> "sys" and systables.tabid = syscolumns.tabid order by 1,5 -- Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; Ft. Collins CO 80523, USofA; 970-491-1244 FAX 970-491-4100 cwoodall@vth1.vth.colostate.edu "There is no 'maybe' in Boolean algebra." -- On Fri, 7 Feb 1997, Don James wrote: > I hate to ask this here but I can not find it anywhere else. I have > checked the manual and the FAQ's and will check anywhere someone can > point me. > > I need to print the schema for my entire database. The format I need > is: > > > Table Name > Field Name > Field Type > Field Size > > I think this should be easy to do, but have not had success. If you > have an answer or can tell me where to find one please e-mail me at > donj@lca.com > > TIA, > > Don >