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

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

When qualified by table_name, * (asterisk) 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. If a table is changed after a view is defined, those changes will not appear if the SELECT * construct is used.