If you need to remove an unused field from an existing record type backed by a database, what is the recommended action?

If you need to remove an unused field from an existing record type backed by a database, what is the recommended action?

• A. Delete the field from the record type and optionally delete the column from the database table
• B. Deactivate the record type
• C. Rename the field in the database
• D. Archive the table

Answer: (A)

When a field in a record type that is backed by a database is no longer needed, clean up both the model and the underlying table to keep things in sync. The recommended action is to delete the field from the record type, and if the column in the database is not used anywhere else, you can drop that column as well. This prevents orphaned fields or columns that could cause confusion, errors, or maintenance headaches later. Before dropping the database column, make sure no reports, integrations, or other parts of the system rely on it, and consider any data retention requirements. Deactivating the record type stops it from being used but leaves the database and field intact. Renaming the field wouldn’t remove it, and archiving the table is overly drastic and would disrupt existing data and relationships.

When a field in a record type that is backed by a database is no longer needed, clean up both the model and the underlying table to keep things in sync. The recommended action is to delete the field from the record type, and if the column in the database is not used anywhere else, you can drop that column as well. This prevents orphaned fields or columns that could cause confusion, errors, or maintenance headaches later. Before dropping the database column, make sure no reports, integrations, or other parts of the system rely on it, and consider any data retention requirements. Deactivating the record type stops it from being used but leaves the database and field intact. Renaming the field wouldn’t remove it, and archiving the table is overly drastic and would disrupt existing data and relationships.