Teradata - How to create a partition

Database
Enthusiast

Teradata - How to create a partition

Hi everyone...

I've started learning about Teradata and I have a doubt on how to create a partition....The table already exists and I suppose I need to do the Alter table sentence, however, I don't know how to create the partition by using a Date field or wharever I need to use.....Can anyone help me with this request?

Thanks in advance :)

1 REPLY
Enthusiast

Re: Teradata - How to create a partition

Hi, I've realized and I was trying to create the partition on a table which contains data, so What I did was create a new table with the same structure and the partition and it worked fine :) thanks