Re: Getting FK->PK relationships
- From: David Thielen <thielen@xxxxxxxxxxxxx>
- Date: Tue, 17 Feb 2009 18:00:27 -0700
Looked at this - it's not worth the effort. Customers on Access we
recomend they switch to Sql Server Express or MySql so we'll just
continue with that.
thanks - dave
On Mon, 16 Feb 2009 09:53:10 GMT, colbertz@xxxxxxxxxxxxxxxxxxxx
(Colbert Zhou [MSFT]) wrote:
Hello Dave,
As far as I know, unlike SQL Server, Access does not support the
INFORMATION_SCHEMA views that return both sides of all FOREIGN KEY
relationships, as well as the name of the foreign key constraint.
As a result, I think, at least based on my research, we cannot write a SQL
statement which can retrieve the scheme information from Access database.
But some researches in the Internet show that we can use the ADOX to
achieve this objective. ADOX is the object model of Microsoft Office Acces.
We can view, create, and modify the structure of Access databases by using
ADOX objects, methods, and properties.
Please read the document to know how to list all tables in the Access
DataBase using ADOX,
http://msdn.microsoft.com/en-us/library/aa165325(office.10).aspx
And read the codes in the following link to know how to find all the
foreign keys in a table using ADOX,
http://sqlserver2000.databases.aspfaq.com/schema-how-do-i-find-all-the-forei
gn-keys-in-a-database.html
I do not go into researches for the FireBird and Progress because they are
not supported from Microsoft. Thanks for your understanding. Hope my links
help for your scenario. And If you have any questions or concerns, please
feel free to let me know. Have a nice day, Dave!
Best regards,
Colbert Zhou (colbertz @online.microsoft.com, remove 'online.')
Microsoft Online Community Support
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@xxxxxxxxxxxxxx
david@at-at-at@windward.dot.dot.net
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com
Cubicle Wars - http://www.windwardreports.com/film.htm
.
- References:
- RE: Getting FK->PK relationships
- From: Colbert Zhou [MSFT]
- RE: Getting FK->PK relationships
- Prev by Date: Re: Getting FK->PK relationships
- Next by Date: RE: full spec of standard selects using INFORMATION_SCHEMA?
- Previous by thread: RE: Getting FK->PK relationships
- Next by thread: Re: Getting FK->PK relationships
- Index(es):
Relevant Pages
|
