Show TOC

Background documentationTable Name (table_name)

 

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.

More Information

CREATE TABLE Statement

CREATE VIEW Statement

CREATE SYNONYM Statement

CREATE SCHEMA Statement

and other SQL statements for Data Definition