Note : Before you proceed with the following instructions, back up the database. If your organization integrates multiple Blackbaud products, refer to the Additional Requirements section of the backup article.
  1. The attribute type can only be changed if the attribute is not used on any record. If the attribute is used, first globally delete the attribute from all records. Be sure to mark the 'Create query of changed records' checkbox.
  2. In Configuration, click Attributes from the navigation bar.
  3. Select the appropriate attribute type. For example, if the attribute is a constituent attribute, select Constituent.
  4. Place the cursor in the Data column in the appropriate row. 
  5. Select Table.
  6. Place the cursor in the Table Name column and select Add a New Table.
  7. Enter the name for the new table and click OK.
  8. In Configuration, click Tables from the navigation bar.
  9. Select the table name from step 7..
  10. Repeat for all other table entries.
  11. If you globally removed the attribute, globally add the attribute back to the record using the output query created in step 1.