Deleting a user-defined table
You can delete user-defined tables that you have added to a data source. If you delete a user-defined table, the Asta Enterprise system's link to the table is removed, but you can choose whether any data that has been entered into the table in Asta Powerproject is deleted from the data source. You may want to keep the data in the data source in order to refer to it using a tool other than Asta Powerproject. Even if you keep the data in the data source, you cannot access it from Asta Powerproject once the user-defined table has been deleted.
If you baseline projects from one data source into another and you delete a user-defined table from one data source, you must also delete it from the data source into which you baseline projects, as both data sources must have the same user-defined table structure.
To delete a user-defined table:
- In the left-hand pane, select the data source from which you want to delete a user-defined table, then select the User Defined Tables folder. The user-defined tables that have been added to the data source are listed in the right-hand pane.
- Select the user-defined table you want to delete.
- Select User Defined Tables from the Custom menu, then select the Delete command. A dialog appears asking whether you want to completely delete the user-defined table and its data, or whether you want to delete the table but maintain any data that has been entered into it.
- Click Yes
to delete the table and any associated data, click No
to delete the table but maintain the data in the data source, or click
Cancel to abandon the deletion.
If you are deleting a user-defined table from a type of data source other than direct connection (ADO), the user-defined table deletion process is complete. If you are deleting a user-defined table from a direct connection data source, a dialog appears asking if you want Server Admin to generate an SQL file that you can run to delete the user-defined table from the data source.
- Click Yes to create an SQL file, or click No if you do not want to create the SQL file. If you choose not to create an SQL file, you will have to delete the user-defined table from the data source manually.
- If you choose to create an SQL file, enter a path and file name for the file.
- Enter exit at the Enterprise server command prompt to shut down the server.
- Execute the SQL file that is output in Query Analyzer to delete the user-defined table from the data source.
- Restart the Enterprise server.