Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Saurabh Gupta (SaurabhG7566)
Bank Of America

Bank Of America
US
SaurabhG7566 Member since 2018 15 posts
Bank Of America
Posted: Jul 19, 2021
Last activity: Jul 19, 2021
Posted: 19 Jul 2021 18:09 EDT
Last activity: 19 Jul 2021 18:14 EDT
Closed

Drop Partition of DB table

Hi,

 

Is it possible to drop the partition using direct SQL in Connect-SQL or is there any other way to drop partition.

The reason we are looking to drop partition is because table is growing and we would like to implement a periodic process(agent) to drop last partition.

To see attachments, please log in.
Pega Platform 7.1.8
Data Integration
Financial Services
Senior System Architect

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice