SQL Tables

The following are the main features of SQL tables in Microsoft® Repository version 2.0:

• The Repository 2.0 SQL tables are extensively revised for versioning. SQL views that match Repository version 1.0 SQL queries executed on a repository database in which all objects have one version should work with no change.
  
  
• Repository 1.0 SQL queries executed on a repository in which multiple versions of objects exist will likely execute to completion, but their semantics should be reviewed in light of versioning. In certain situations multiple versions of the same object may be returned by the queries, which a Repository 1.0 application might not expect.
  
  
• The table RTblSites does not have the NextLocalID column in Repository 2.0.
  
  
• The table RTblClassDefs has a new column called VerPropDescs where the class definition is stored in Repository 2.0. The column PropDescs contains only null values and is no longer used. However, it is retained for compatibility.