Manage Tables

Use the Administration Console 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 rules 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 constraint 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
  Incremental data transfer lets you transfer data to Adaptive Server 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.
• Manage Reorganization
  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.
• Managing Table Statistics
  Manage tables, indexes, and columns statistics which are used to estimate query costs.
• 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 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.
• Deleting a Table
  Sybase Control Center helps you delete database objects, or the database itself.