Printing a schema
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
}
Two choices come to mind first. Using 4gl or similar, you can read the
appropriate system tables and make your own report. Or, you can use
dbschema -d dbname > filename (e.g. for Unix) and sed/awk your waythrough the format. I personally do it both ways, but I'd prefer to use
4gl, since it's portable and easier for others to work with.
Tim