Odd tables in one of our user databases

  • Quite some time ago, way back when we were using either SQL Server 6.5 or SQL Server 7.0, we had several tables suddenly appear in one of our user tables. Way back when we didn’t know why they appeared, or what they were about, but we felt they might have been created as a part of our development process back then. For example, for a while back then we were using something called “Component Repository”, which was a part of Visual Studio 6.0 (and perhaps even Visual Studio 5, I can’t remember anymore), and so we thought that maybe these tables were all a part of that. We do have a SQL Server database called “ComponentRepository” as well, where Visual Studio 6 would store our components, but even so we weren’t sure what these tables were all about. And the weird thing is they’re only in one of our user databases. Anyway, I’d like to know if anyone knows what these tables are about and what might have created them. Here are the table names:

    UnkRTblVersions

    UnkRTblRelships

    UnkRTblSites

    UnkRTblProps

    UnkRTblRelshipProps

    UnkRTblPropDefs

    UnkRTblRelColDefs

    UnkRTblIfaceDefs

    UnkRTblClassDefs

    UnkRTblRelshipDefs

    UnkRTblTypeLibs

    UnkRTblIfaceMem

    UnkRTblWorkspaceItems

    UnkRTblDatabaseVersion

    UnkRTblVersionAdminInfo

    UnkRTblParameterDef

    UnkRTblIfaceHier

    UnkRTblNamedObj

    Kindest Regards, Rod Connect with me on LinkedIn.

  • Can't find anything with searching and not sure what these are for. Hopefully someone will reply. What type of data is in there?

  • Steve Jones - Editor (10/9/2008)


    Can't find anything with searching and not sure what these are for. Hopefully someone will reply. What type of data is in there?

    I checked all 18 tables and they're all empty. I've checked the data types used in the columns, and they're normal, although they aren't things that we typically use. For example the UnkRTblClassDefs table has the following definition:

    CREATE TABLE [dbo].[UnkRTblClassDefs](

    [IntID] [binary](8) NOT NULL,

    [Z_BranchID_Z] [int] NOT NULL,

    [Z_VS_Z] [int] NOT NULL,

    [Z_VE_Z] [int] NOT NULL,

    [ClassID] [binary](16) NOT NULL,

    [VerPropDescs] [image] NULL,

    [PropDescs] [image] NULL DEFAULT (null),

    [ViewName] [varchar](128) NULL,

    [ViewFlags] [int] NULL,

    CONSTRAINT [RDexClassDefs] PRIMARY KEY CLUSTERED

    (

    [IntID] ASC,

    [Z_BranchID_Z] ASC,

    [Z_VS_Z] ASC

    )WITH (...) ON [PRIMARY]

    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

    I just had another thought. I believe it is possible for either MS Excel or MS Access to try and re-engineer a database. Could it be possible that someone did that, and this is just artifact of that attempt?

    Kindest Regards, Rod Connect with me on LinkedIn.

  • Not sure about the "UNK" but this may help

    http://msdn.microsoft.com/en-us/library/aa275699(SQL.80).aspx

    RTblVersions stores version information about repository objects.

    http://msdn.microsoft.com/en-us/library/aa275694(SQL.80).aspx

    RTblIfaceDefs contains one row for each interface that is defined in a repository database.

    The second link should take you to the repository SQL schema

    Matt

    _______________________________________________________________________
    Work smarter not harder.

  • That does help, Matt. Some of those column names in those Rtb* tables are identically named as those in my mysterious UnK* tables. That at least suggests to me that it was some Microsoft application that had been used to do something or other. I don't know what, and most likely whoever did it (and that might have been me) weren't aware, at the time, that these tables would be created for whatever reason.

    Kindest Regards, Rod Connect with me on LinkedIn.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply