Show TOC

Background documentationTable Name (table_name) Locate this document in the navigation structure

 

A table_name identifies a table.

Structure

Syntax Syntax

  1. <table_name> ::=
      [<schema_name>.]<identifier>
End of the code.

Neither the schema name nor the identifier can be longer than 32 characters.

Examples

SQL Tutorial, Tables

Explanation

Tables and view tables are identified by table names. A table name consists of a schema_name and an identifier. All table identifiers in one schema must be different from one another.

The database system uses certain table names for internal purposes. The identifiers of these tables begin with SYS. To avoid naming conflicts, therefore, you should not use table names that start with SYS.