A table is a basic database object that is used to store database information. Tables are made up of fixed length rows and variable length columns. Additionally, you can create one of your columns as an IDENTITY column. While you are defining the table, you will also be given the opportunity to define indexes, constraints, and triggers. You can also add these definitions later. Creating a table results in a physical file being created on the system.
You can also create a Materialized query table. For information about partitioning tables, see Partitioning overview.
Some of the tasks that you can perform on tables are:
- Create a table
- Copy column definitions
- Insert a column
- Delete a column
- Insert a row
- Delete a row
- Reset usage counts
- Show indexes
- Show Materialized query table
- Show Related
- Edit data in a table
- Copy a table
- Move a table
- Display table description information
- Reorganize a table
- Rename a table
- Display locked rows
- Display journal information for a table
- Start or stop a journal for a table
- View contents of a table
For more information about tables, see Tables in the SQL Reference topic in the
Information Center .