15.10 - * - 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)

All columns from all tables referenced in the FROM clause are to be returned.

When qualified by table_name, * specifies that all columns of only the user base table or view specified by table_name are to be returned.

View columns are explicitly enumerated when views are defined; therefore, if a table is changed after a view is defined, those changes will not appear if the SELECT * construct is used.