[progress Communities] [progress Openedge Abl] Forum Post: Re: Sql Help Document For...

  • Thread starter Thread starter mrahaman
  • Start date Start date
Status
Not open for further replies.
M

mrahaman

Guest
Hi, Following are answers to your questions 1/2) ROWID is used for regular tables and PRO_PARTN_ROWID is used for partitioned table. ROWID and PRO_PARTN_ROWID are unique in an area.So ROWID/PRO_PARTN_ROWID and area together is unique across the database. All schema tables reside in schema area and schema tables are not partitioned, so ROWID can be used for schema tables. 3) Available indexes can be obtained from schema table SYSINDEXES. Refer to the following link documentation.progress.com/.../ (Please follow Data Management->SQL Reference->OpenEdge SQL system Catalog Tables) 4) Can be obtained from SYSTABLES and SYSCOLUMNS. documentation.progress.com/.../ (Please follow Data Management->SQL Reference->OpenEdge SQL system Catalog Tables) 5) To get primary index, SYSINDEXES can be queried with the primary key column name. 6) Look into the link provided documentation.progress.com/.../ (Please follow Data Management->SQL Reference->OpenEdge SQL Statements->SELECT) Thanks, Masiur

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