I have a record type that has been deprecated. I'd like to drop the table from the database and rename the record type to start with DEPRECATED; then disable data sync and disconnect the table. However this record will become invalid and fail to deploy. What's the best practice?
Discussion posts and replies are publicly visible
I think the most important step is to restrict access by modifying the security settings and deploying that change to all environments.
After making sure that there are no dependencies anymore, you will have to manually delete the record and drop the table on all environments. While you could drop a table using a deployment SQL script, that would break the record without the option to delete that record through a deployment.
Wen Huynh I agree with Stefan Helzle as we faced this issue.We perform manually delete the record and drop the table on all environments.