Viewing a create table statement

If you're familiar with SQL (Structured Query Language), you may want to view the create table statement that Infor Public Sector uses to generate a personalized table. Viewing the create table statement can provide a clearer picture of the structure of the table, which can help you complete certain tasks, such as generating a report.

  1. Select System > Agency Personalization > Schema Manager.
  2. In the Enhancement Product Families tree, browse to the table definition whose create table statement you want to view.
  3. Right-click the table definition node and select Show Create Table Statement.
    Infor Public Sector shows the SQL statement in a dialog box.