Manage Tables

Use the Administration Console option on your Adaptive Server to create or modify tables and table objects.

• Creating a User Table
  Create a user table to store and provide access to user data.
• Creating a Proxy Table
  Create a proxy table to access data on remote servers.
• 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.
• Creating a Trigger
  Create a trigger on a table to enable checks whenever data is inserted, updated, or deleted.
• 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 rule to a column.
• Placing a Table on a Segment
  Using a segment to put a table on a specific database device can improve Adaptive Server 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 Primary Key
  Creating a primary key constraints ensures that no two rows in a table have the same values in the specified columns.
• Creating a Unique Constraint
  Use a unique constraint to ensure that no two rows have the same values in the columns of the constraint.
• Incrementally Transferring Data
  Use incremental transfer to transfer data incrementally rather than transferring an entire table.
• Bulk Copying Data
  You can use bulk copy to copy data into or out of a table.
• Setting Permissions
  Grant or revoke permissions on tables for users, groups, and roles.
• Managing Partitions
  Use partitioning to divide large tables and indexes into smaller, more manageable pieces.
• Managing Table Statistics
  Manage tables, indexes, and columns statistics which are used to estimate query costs.
• Table Properties
  Use the Tables Properties wizard to modify device usage, compression, permissions, cache, and the locking scheme.
• Column Properties
  Use the Columns Properties wizard to change permissions, create check constraints, specify encryption keys, and bind rules and defaults to columns.
• Index Properties
  Use the Index Properties wizard to modify cache bindings, specify a device segment, and change index values.
• Trigger Properties
  The Trigger Properties wizard shows the selected trigger options and objects referenced by the trigger.
• Foreign Key Properties
  The Foreign Key Properties wizard shows current foreign key options and the matching primary keys.
• Check Constraint Properties
  The Check Constraint Properties wizard shows the check constraint definitions.
• Partition Properties
  The Partition Properties wizard shows the partition name, strategy, and type.