Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)Français (France)Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

OpenEdge Database Tools

Table Tasks

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Data Dictionary Basics
    • Start the Data Dictionary
    • Data Dictionary menu bar
  • Database Tasks
    • Create a database
    • Connect to a database
    • Switch to another connected database
    • Disconnect a database
    • View session information
    • Dump data definitions
    • Dump Change Data Capture policies
    • Create an incremental data definition file
    • Create a parameter file
    • Edit a parameter file
    • Load data definitions
    • Load Change Data Capture policies
  • Table Tasks
    • Create a table
      • Specify validation criteria
      • Specify triggers
      • Specify string attributes
    • Modify a table
    • Delete a table
    • Freeze or unfreeze a table
    • Generate a table report
      • Generate a Detailed Table Report
      • Generate a Quick Table Report
      • Generate a Table Relations Report
    • Dump table contents
      • Dump user table contents
      • Dump data from a multi-tenant database
    • Load table contents
      • Load user table contents
      • Reconstruct bad load records
      • Load data into a multi-tenant database
    • Binary dump and load
      • Perform the binary dump
      • Perform the binary load
    • Create a bulk loader description file
    • Generate an include file
      • Create a FORM statement include file
      • Create a DEFINE WORK-TABLE statement include file:
  • Field Tasks
    • Add a field
    • Modify a field
    • Change a field data type from integer to INT64
    • Change a field name globally
    • Copy a field
    • Delete a field
    • Change field order
    • Generate a Quick Field Report
    • Adjust the Field Width
  • Index Tasks
    • Create an index
    • Modify an index
      • Change the primary index for a table
      • Rename an index
      • Deactivate an index
    • Delete an index
    • Generate a Quick Index Report
  • Sequence Tasks
    • Create a sequence
    • Modify a sequence
    • Delete a sequence
    • Dump sequence definitions
    • Dump sequence current values
    • Load sequence current values
    • Generate a sequence report
  • Trigger Tasks
    • Create a trigger
    • Create a trigger from an existing field
    • Create a DELETE trigger for a CDC change table
    • Modify a trigger
      • Modify a table trigger
      • Modify a field trigger
    • Delete a trigger
      • Delete a table trigger
      • Delete a field trigger
    • Generate a trigger report
  • Database Menu Reference
    • Database menu
    • Select Working Database option
    • Create option
    • Connect option
    • Disconnect option
    • Reports option
      • Detailed Table Report option
      • Quick Table Report option
      • Quick Field Report option
      • Quick Index Report
      • Sequence Report option
      • Trigger Report option
      • User Report option
      • Table Relations Report option
      • Storage Areas Report option
      • Verify Data Width Report option
      • Alternate Buffer Pool Report option
      • Auditing Reports option
        • Track Audit Policy Changes report
        • Track Database Schema Changes report
        • Track Audit Data Administration (Dump/Load) report
        • Track Application Data Administration (Dump/Load) report
        • Track User Account Changes report
        • Track Security Permissions Changes report
        • Track SQL Permissions Changes report
        • Track Authentication System Changes report
        • Client Session Authentication report
        • Database Administration Utilities report
        • Database Access report (Login/Logout/etc)
        • Track Encryption Policy Changes report
        • Track Key-store Changes report
        • Database Encryption Administration (Utilities) report
        • Custom Audit Data Filter report
        • OpenEdge Auditing Report Options dialog box
      • Encryption Policy Reports option
        • Quick Encryption Policies report
        • Detailed Encryption Policies report
    • Exit option
  • Schema Menu Reference
    • Schema menu
    • Modify Table option
      • Validation option
      • Table Triggers option
      • String Attributes option
    • Add New Table option
    • Delete Table(s) option
    • Field Editor option
      • Add
      • Field Triggers
      • View As
      • GoIndex option
    • Reorder Fields option
    • Global Field Name Change option
    • Index Editor option
    • Sequence Editor option
    • Adjust Field Width option
  • Admin Menu Reference
    • Admin menu
    • Dump Data and Definitions option
      • Data Definitions (.df file) option
      • Table Contents (.d file) option
      • SQL Views option
      • User Table Contents option
      • Security Domains option
      • Security Permissions option
      • Auto-Connect Records Only option
      • Collation Tables option
      • Sequences Definitions option
      • Sequences Current Values option
      • Database Identification Properties option
      • Database Options
      • Audit Policies option
        • Dump as XML
        • Dump as Text
        • Application Audit Events
      • Audit Data option
      • Create Incremental .df File option
        • Batch Incremental utility
      • Change Data Capture Policies (.cd file) option
    • Load Data and Definitions option
      • Data Definitions (.df file) option
      • Table Contents (.d file) option
      • SQL Views option
      • User Table Contents option
      • Security Domains option
      • Security Permissions option
      • Sequences Current Values option
      • Reconstruct Bad Load Records option
      • Database Identification Properties option
      • Database Options option
      • Audit Policies option
        • Load as XML
        • Load as Text option
        • Application Audit Events option
      • Audit Data option
      • Change Data Capture Policies (.cd file) option
    • Database Identification option
      • Database Identification Maintenance option
        • New Database Passkey/Identifier dialog box
      • Database Identification History option
    • Security option
      • Edit User List option
      • Change your password
      • Edit Data Security
      • Edit Audit Permissions option
      • Security Administrators option
      • Disallow Blank User Access option
      • User Report option
      • Domain Maintenance option
        • Authentication Systems
        • Domains
      • Encryption Policies
        • Edit Encryption Policy
        • Generate Encryption Keys
        • Encryption Policy History
    • Export Data option
    • Import Data option
      • Fixed-Length option
      • dBASE Definitions option
    • Create Bulk Loader Description File option
    • Database options
    • Enabling large key entries
    • Alternate Buffer Pool Maintenance
  • Advanced Menus Reference
    • DataServer menu
    • Utilities menu
      • Editor for Parameter Files option
      • Quoter Functions option
        • Entire Lines option
        • By Delimiter option
        • By Column Ranges option
      • Generate Include Files option
        • ASSIGN Statement option
        • FORM Statement option
        • DEFINE WORK-TABLE Statement option
      • Edit OpenEdge Auto-Connect List option
      • Freeze/Unfreeze Table option
      • Index Deactivation option
      • Information option
    • PRO/SQL menu options
      • PRO/SQL View Report option
      • Dump as CREATE VIEW Statement option
      • Dump as CREATE TABLE Statements option
    • Tools menu
Table of Contents

Table Tasks

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: March 30, 2020
  • 1 minute read
    • OpenEdge
    • Version 12.2
    • Documentation

This topic describes procedures for using the Data Dictionary to perform the following administrative tasks for tables and files:

Contents
  • Create a table
  • Modify a table
  • Delete a table
  • Freeze or unfreeze a table
  • Generate a table report
  • Dump table contents
  • Load table contents
  • Binary dump and load
  • Create a bulk loader description file
  • Generate an include file
TitleResults for “How to create a CRG?”Also Available inAlert