Except "ID" column, I don;t have any primary key column in TableA and all other columns having duplicate values. Moreover the "ID" is the only column which is references key column of other child tables. So I couldn't able to altering primary key.

In these scenario what about table partition ?

Please correct me if i'm wrong. So, we are not able to convert the non partition table to partition table ?

if we can, Kindly let me know, if you have an example on these ?

Thanks for your reply in time and request your help.

thanks & regards

Saravanakumar.R