Delete Tables

Warning: Never remove any standard EQuIS tables unless instructed by EarthSoft to do so. Outside of this specific circumstance, EarthSoft cannot provide support for deleting standard EQuIS tables.

Removing the following types of tables in an EQuIS database requires additional steps:

•out-of-date standard tables, when (and only when) instructed by EarthSoft

•custom tables from a schema reserved for standard EQuIS tables (i.e., dbo), such as dbo.dt_custom_table instead of custom.dt_custom_table

Note: Per the EQuIS Database Modification Compliance Requirements, database administrators can add tables within a custom schema to their EQuIS databases.

For EQuIS Online sites, EarthSoft can delete such tables upon request. For non-hosted databases, take the following steps to delete such tables:

1.Consult with database users regarding any data contained in these tables prior to deletion so that users can preserve any needed data.

2.Check if any database dependencies will be affected, such as custom views that reference the table, and make a plan to address those objects.

3.Back up the database (or, for automatic point-in-time database backups, note the time prior to the next step).

4.Remove the table.

5.Run the following procedures, in order:

exec equis.table_order
exec equis.refresh_schema dbo, null
exec equis.table_row_count_build

These procedures must be run because the equis.table_row_count stored procedure will fail if the list of tables being counted no longer matches the tables within the database. Errors like " Cannot Find Table 0 or 4" or the following will appear upon login or opening tables.

Invalid object name 'dbo.dt_custom_table'

Could not use view or function 'equis.table_row_count' because of binding errors.

at EarthSoft.Common.Data.Connection.Fill(DataSet ds, String tableName, IDbCommand Command)

at EarthSoft.Reports.OpenDialog.Setup()

Note that if auditing triggers have been manually deleted but have not been turned off in the XT_COLUMN table, the auditing triggers will be recreated at this time.

Users with sufficient SQL permissions can delete custom tables in custom schemas, such as custom.dt_custom_table, without running EQuIS stored procedures.