Tables

Use SAP Control Center to create or modify tables and table objects.

• Creating a User or Proxy Table
  Create a user or proxy table to store and provide access to user data.
• Creating a Column
  Add a column to an existing table.
• Creating an Index
  An index provides quick access to data in a table, based on the values in specified columns.
• Restoring Table Data
  Restore table data from an archive or stand-by database.
• Creating a Foreign Key
  Create a foreign key to constrain a column based on values in a reference table.
• Creating a Check Constraint
  Creating a check constraint specifies a condition that any value must pass before it is inserted into the table.
• Checking Table Consistency
  Check and repair the logical and physical consistency of a table.
• Binding Defaults and Rules to a Column
  Specify constraints on column data by binding defaults or rules to a column.
• Placing a Table on a Segment
  Using a segment to put a table on a specific database device can improve performance and give increased control over placement, size, and space usage of database objects.
• Setting the Table Locking Scheme
  Choose or alter a locking scheme based on required performance.
• Creating a Unique Constraint or Primary Key
  Creating a unique constraint or primary key constraint to ensure that no two rows in a table have the same values in the specified columns.
• Manage Table Compression
  The compression advisor provides an estimate of the percentage of space you can save by compressing a user table.
• Manage Index Compression
  Use the Create Table and Create Index wizards to set index compression. You can subsequently turn it on or off on the table, index, or local index property screens.
• Manage Triggers
  A trigger is a special type of procedure attached to a table column that goes into effect when a user changes the table. Triggers execute immediately after data modification statements are completed.
• Incrementally Transferring Data
  Incremental data transfer lets you transfer data to SAP ASE or other products.
• Bulk Copying Data
  You can use bulk copy to copy data into or out of a table.
• Setting Table or Column Permissions
  Grant or revoke permissions on tables or columns for users, groups, and roles.
• Manage Partitions
  Use partitioning to divide large tables and indexes into smaller, more manageable pieces.
• Reorganize Tables and Table Objects
  Reorganize tables, table partitions, indexes, and index partitions to improve performance by reclaiming unused page space, removing row forwarding, or rewriting all table rows to new pages, depending on the option used.
• Table Properties
  Use the Tables Properties window to modify device usage, compression, permissions, cache, and the locking scheme.
• Column Properties
  Use the Columns Properties window to change permissions, create check constraints, specify encryption keys, and bind rules and defaults to columns.
• Index Properties
  Use the Index Properties window to modify cache bindings, specify a device segment, and change index values.
• Foreign Key Properties
  The Foreign Key Properties window shows current foreign key options and the matching primary keys.
• Check Constraint Properties
  The Check Constraint Properties window shows the check constraint definitions.
• Partition Properties
  The Partition Properties window shows the partition name, strategy, and type.
• Deleting a Table
  Use SAP Control Center to delete tables.
• Deleting an Index
  Use SAP Control Center to delete indexes created on user tables.