Kbase P17508: How to dump the schema components for a SQL-92 database table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
How to dump the schema components for a SQL-92 database table?
FACT(s) (Environment):
Progress 9.1x
FIX:
Use the SQLSCHEMA command line utility to write SQL-92 database schema components to an output file.
sqlschema -u user_name [-a password] -t [owner_name].table_name database_name
Database server must be configured for SQL-92 access to use the utility.
SQLSCHEMA utility captures table definitions, table constraints, views, stored procedures and triggers.