Teradata: Extract month and year from date

 extract (year from date1)

 extract (month from date1)

Teradata: Backup table with data

create table table1_bkup as
table1 with data

Teradata: List columns of a table

select
*
from dbc.columns
where tablename ='table1'
and databasename = 'database1'

Teradata: List tables in database

select
*
from dbc.tables
where databasename='database'
and tablekind = 'T'

Teradata: Add column with default value

alter table table1 add col1 int default 0

Teradata: Rename table

rename table table1 to table2

Teradata: Add column

alter table table1 add x int;

Teradata SQL: Drop column

alter table table1 drop col1

Teradata SQL: Update column name

alter table table1 rename col1 to col1_updated