Thanks for the reply

dropping and recreating the partition every day is not a good idea since it will be time consuming, and requires DBA intervention.

I just wanted to truncate the partition, and have the transactions of the new day to be inserted in this partition.

also adding a new column in the table is not possible, since we don't have the source code of the application, so we can't add this column in the insert statement, and we can't add a trigger in the table to populate this column since it has bulk inserts on it, (4-5 millions per day).