Delete Fields, Tables, and Extensions
On this page:
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
- On the start page, choose System under Setup in the main menu.
- Under Data Management, click Page and Data Management.
- Under Database Management, click Manage Database Extensions.
- 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.
Note: Click Undo Delete if you do not want to delete the field. - Click Submit.
- Click Ok to delete the field.
Delete a Table
- On the start page, choose System under Setup in the main menu.
- Under Data Management, click Page and Data Management.
- Under Database Management, click Manage Database Extensions.
- 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
- On the start page, choose System under Setup in the main menu.
- Under Data Management, click Page and Data Management.
- Under Database Management, click Manage Database Extensions.
- 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.