Display Permanent Table - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
spp1591731285373.ditamap
dita:ditavalPath
spp1591731285373.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™
SELECT * FROM riverflow_csv_t;

Result:

datetime              site_no                     Flow              GageHeight             GageHeight2           Precipitation
--------------------  --------  ----------------------  ----------------------  ----------------------  ----------------------
2018-07-05 08:15      9513780    0.00000000000000E 000  -1.44000000000000E 000  -9.80000000000000E-001   0.00000000000000E 000
2018-06-28 10:15      9513780    0.00000000000000E 000  -1.44000000000000E 000  -9.80000000000000E-001   0.00000000000000E 000
2018-07-03 16:30      9513780    0.00000000000000E 000  -1.44000000000000E 000  -9.80000000000000E-001   0.00000000000000E 000
2018-07-11 21:45      9513780    0.00000000000000E 000  -1.44000000000000E 000  -9.80000000000000E-001   1.00000000000000E-002
[...]