Tables -- Working With

  • Altering a table
  • Changing table properties when altering a table
  • Adding columns when altering a table
  • Changing existing columns when altering a table
  • Selecting predefined columns when altering a table
  • Editing column lists when altering a table
  • Defining the primary key when altering a table
  • Changing the primary key when altering a table
  • Adding partitioning key columns when altering a table
  • Removing partitioning key columns when altering a table
  • Adding foreign keys when altering a table
  • Changing foreign keys when altering a table
  • Adding check constraints when altering a table
  • Changing check constraints when altering a table
  • Changing a table's quiesce mode
  • Copying a table
  • Creating a table
  • Defining table properties when creating a table
  • Adding columns when creating a table
  • Selecting predefined columns when creating a table
  • Editing column lists when creating a table
  • Defining the primary key when creating a table
  • Defining the partitioning key when creating a table
  • Adding foreign keys when creating a table
  • Adding check constraints when creating a table
  • Creating a table using a SmartGuide
  • Dropping a table
  • Exporting a file
  • Specifying file options when exporting a file
  • Storing large objects in separate files when exporting a file
  • Adding column names when exporting a file
  • Granting and revoking table privileges
  • Granting and revoking table privileges for users
  • Granting and revoking table privileges for groups
  • Importing Tables
  • Importing a file into a table
  • Creating a new table from an input file
  • Loading data into a table
  • Specifying the location and file type to be loaded
  • Specifying how to load ASC data into the table columns
  • Specifying how to load DEL data into the table columns
  • Specifying how to load IXF data into the table columns
  • Specifying conditions for loading data file rows into table columns
  • Specifying options to collect statistics when loading data into a table
  • Specifying options for saving a copy of changes when loading data into a table
  • Specifying various options for loading data into a table
  • Restarting an interrupted load operation
  • Terminating an interrupted load operation
  • Renaming a table
  • Reorganizing a table
  • Running statistics for a table
  • Turning off constraint checking for a table
  • Turning on constraint checking for a table and checking the data
  • Turning on constraint checking for a table without checking the table data
  • Viewing a sample of a table's contents
  • When to manually set constraint checking for a table
  • Basic table copy

    •