March 22, 2006 at 1:53 pm
One of our reporting departments would like to have a rich metadata store for all tables used in the company's reporting. This metadata would be stored in a user table in the reporting database, where the reprting tables are also stored.
The suggestion has been to combine sysobjects and syscolumns tables with this new user table to give a business view and technical view of all the columns in the reporting tables.
Any feedback regading this design, drawbacks, etc.?
March 22, 2006 at 2:00 pm
What your talking about has been pretty standard methodology through my experience, and works well. However, with the new SYSSCHEMA views, and them actually having the metadata you would need, I'd suggest using them rather than the sysobjects and syscolumns tables directly, strictly to prevent upgrades from causing you re-writes in the future......although, to be honest, I've never been much bothered by having to modify a little code to accommodate an upgrade myself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply