15.10 - table_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

Name of a user base table or view.

This can itself be a recursive reference in the recursive statement portion of the view definition. You cannot make a reference to a recursive view in the seed statement of the view definition.

Use a table_name.* specification in the select list to define the specific table from which rows are to be returned when two or more tables are referenced in the FROM clause.

You cannot create or replace a view on a queue table (see CREATE TABLE).

database_name
user_name
Containing database or user for table_name if something other than the current database or user.