Teradata Create Table example - SET/Multiset/CTAS

Опубликовано: 20 Ноябрь 2024
на канале: ETL-SQL

4,751

Free SQL Pattern Training: https://etlsql.kartra.com/page/sps-fr...

In this video, we will talk about basic queries to create table in Teradata. Then we will talk about SET/MULTISET and we will see the difference between the two with examples.

Also we will talk about CTAS or Create Table AS options and will see what is the advantage and disadvantage of each option.
Do we lose Table Level & Column Level properties like default, NULL, Date formats etc ? Check the video where we see it with examples.
If you prefer reading than watching then refer the below link:
http://etl-sql.com/teradata-create-ta...