[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Dump of SQL View

  • Thread starter Thread starter Rob Debbage
  • Start date Start date
Status
Not open for further replies.
R

Rob Debbage

Guest
Hi Mark, Try the SQLSCHEMA utility from PROENV. For example, sqlschema -u -a -t . progress:T: : : It will list the original View definition, so something like: create view "MYSCHEMA"."SALESREP" ( "RepName", "Region", "SalesRep", "MonthQuota" ) as SELECT * FROM PUB . SALESREP WHERE SALESREP = 'BBB' ; It's also possible to get the definitions by querying SYSPROGRESS.SYSVIEWS. HTH, Rob

Continue reading...
 
Status
Not open for further replies.
Back
Top