October 9, 2008 at 9:38 am
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.
October 9, 2008 at 9:46 am
Can't find anything with searching and not sure what these are for. Hopefully someone will reply. What type of data is in there?
October 9, 2008 at 10:18 am
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.
October 10, 2008 at 7:45 am
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.
October 10, 2008 at 9:52 am
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