Friday, February 24, 2012

Generate Data Model

Hi,
I need to verify the relationship between tables. Is there
any possible to generate the output of the existing Data
Model?
Thanks,
RegardsHi
Look at sp_foreignkeys system stored procedure
Build a diagram to show relationship between tables.
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:bea401c47a0c$d91206d0$a301280a@.phx.gbl...
> Hi,
> I need to verify the relationship between tables. Is there
> any possible to generate the output of the existing Data
> Model?
> Thanks,
> Regards|||I would build a diagram now also... Or you might use a 3rd part modelling
tool like Erwin..
Don't get too attached to the SQL DB Diagram... I don't think it will be in
the next version of SQL.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:bea401c47a0c$d91206d0$a301280a@.phx.gbl...
> Hi,
> I need to verify the relationship between tables. Is there
> any possible to generate the output of the existing Data
> Model?
> Thanks,
> Regards

No comments:

Post a Comment