Delete Fields, Tables, and Extensions
Once extensions, tables, and fields have been created, you may find it necessary to delete one or more of those items. When deleting an existing field in an extension table, note that the field may contain data. If you delete the field, that data will be permanently deleted. When deleting an existing table from an extension, note that table may contain data. If you delete the table, that data will be permanently deleted. When deleting an existing extension, note that the extension contains at least one table, which may contain data. If you delete the extension, that data will be permanently deleted.
Delete a Field
- Navigate to the Database Extensions page.
- Choose the PowerSchool table that you want to work with from. To view a longer list of PowerSchool tables, choose Other, and then select a table.
- Select the Advanced Extension option.
- Click Next.
- Click Next.
- Select the Extension Table Name option that you want to work with.
- Click Next.
- Click the Delete icon next to the field name you want to delete.
- Note the Status changes from Existing to Delete Pending.
Click Undo Delete if you do not want to delete the field. - Click Submit.
- Click Ok to delete the field.
Delete a Table
- Navigate to the Database Extensions page.
- Choose the PowerSchool table that you want to work with from. To view a longer list of PowerSchool tables, choose Other, and then select a table.
- Select the Advanced Extension option.
- Click Next.
- Click Next.
- Select the Extension Table Name option that you want to delete.
- Click the Delete icon next to the selected extension table name.
- Click Ok to delete the field.
Delete an Extension
- Navigate to the Database Extensions page.
- Choose the PowerSchool table that you want to work with from. To view a longer list of PowerSchool tables, choose Other, and then select a table.
- Select the Advanced Extension option.
- Click Next.
- Select the Extension Name option that you want to delete.
- Click the Delete icon next to the selected extension name.
- Click Ok to delete the field.