You can use the screen in the 1024 Tools tab to generate SQL for the Ivo schema -





Use the left-hand dropdown list to select a table. You can then generate the SQL to -

  • Create the table
  • Add the default records for the table (eg. for a lookup table)
  • Create the indexes for the table



Use the right-hand dropdown list to select a field from the selected table. You can then generate the SQL to -

  • Add that field to the table
  • Alter the field



You can then paste the SQL in an ad-hoc query to enact the changes -