Table overview

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:

For more information about tables, see Tables in the SQL Reference topic in the Information Center Link to Information center.