November 3, 2005 at 8:02 am
Sorry guys/gals this is a really dumb question. I'm new to sql and am currently using with a mapping piece of software ESRI ArcSDE. We are storing spatial information on sql and naming the tables accordingly but how can I tell what a, d, f, i, s and any other tables are linked or required. The ESRI documentation is sketchy at best and with a few trial runs of loading data I dont want tables being left hanging around. Any help would be appreciated.
Cheers, Keith
November 3, 2005 at 10:46 am
Hi Keith,
Do you have access to Visio? One of the versions of Visio allows you to reverse engineer a database and includes support for all of the defined foreign keys and so on.
The same capability exists in Enterprise Manager. In EM, select server group | server name | databases | database name | diagrams. I the right hand pane, right click and select new database diagram. Select all of the tables you care about and add them to the diagram.
Hope this helps
Wayne
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply