Hello all,
I have searched high and low and can't locate a procedure to remove system tables. I have read through [UP_POPULATE_REFERENCE_METADATA] and it doesn't seem to remove the table and any references.
There is nothing in the help documentation about deleting system tables. If anyone has removed/inactivated local/system tables and know how to do this or can point me in the direction of instructions I would be much obliged.
Thank you,-Lisa
Local reference tables are exposed to the System Tables module based on rows in TR_REFERENCE_TABLE and TR_REFERENCE_COLUMN. (When you assign rights to system tables with Tessitura Security, you are modifying TX_REFTABLE_USERGROUP, which creates a relationship to TR_REFERENCE_TABLE.)
However, removing rows from the TR_REFERENCE_ tables may still allow them to be repopulated by future runs of UP_POPULATE_REFERENCE_METADATA, which by default picks up all user tables in the database that have a prefix of "LTR_", adding rows for them to the TR_REFERENCE_ tables. So if you want these tables gone for good, you will need to drop them manually in SSMS. There isn't a built in utility that does DROP TABLE on user tables.
Do note that UP_POPULATE_REFERENCE_METADATA never added the tables to your database in the first place, it only does what it says in the procedure name, which is to populate metadata rows in TR_REFERENCE_TABLE and _COLUMN. This doesn't create the data structure inside the database where the table content is actually stored on disk. Someone had to have done a manual CREATE TABLE at some point for it to exist in the schema.