Follow

What is the "_L" table and what are the deployment steps

The List table is a many to many table, that links specific records in the Raw table with error and/or warning messages associated with the record.

One record in the Raw table can be associated with one or more messages from the Message table. The severity flag in the Message table determines if the message is considered as a warning or error.

The deployment happens in the following steps

  1. Drop any user-defined functions used by the table
    1. Find by timeXtender object ID and type
    2. Find by name and schema
    3. Find by name in default schema (dbo)
  2. Drop existing table
    1. Find by name and schema
    2. Find by timeXtender ID and type
    3. Find by name in default schema (dbo)
  3. Create new table
    1. Table is tagged with timeXtender object ID and type using extended properties
  4. Create new functions
    1. User-defined functions are tagged with timeXtender object ID and type using extended properties

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.