B. not that easy, need recreate table. C. what's 'linking field', you mean partition column?
Forum Rules