Is it possible to modify partition range in nonempty tables using alter table statement or by any other methods. If so, please share the syntax.
Thanks in advance!
this is covered in the documentation, in the SQL Data Definition Language - Detailed Topics / Syntax and Examples chapters.
You can search for "ADD RANGE", "DROP RANGE" keywords in the Advanced search to find those examples.
The documentation can be downloaded here: http://www.info.teradata.com/Datawarehouse/eBrowseBy.cfm?page=TeradataDatabase. Choose the database version on the top right corner, and then download either separate chapters, or - better - the whole User Documentation CD-ROM.
Here the scenario, I have table partitioned by two columns(effective_Start_date and last_updated_date) and the table have data. partition range for effective start date is from 2008- 01-01 to 2013-12-01 each 1 month interval. My request is to modify the partition range from 2006-01-01 to 2013-12-01 without deleting the data. Please let me know is it possible in teradata 13.10V.