15.10 - table_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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.