CODEWITHSUNDEEP
sqldatabasems-accessms-access-2013
BootyBump
BootyBump

Reputation: 59

MS Access: Viewing SQL for tables, relationships etc and not just queries

I am trying to get some help online for my Access created database in an SQL chatroom but I am being asked to show the SQL for it. I am unable to do this and it seems the SQL View function only shows up for queries and not tables or relationships etc.

Nothing comes up online and I have been told that it is apparently possible to code in raw SQL in Access for everything (and I imagine view the database code) so could someone please tell me how I might go about this?

Upvotes: 1

Views: 274

Answers (1)

Kefash
Kefash

Reputation: 533

Its much easier to just create a screenshot of the relationship window and send it to them. If you are using window 7 you could just use the snipping tool on the fly.:)

Other thing you could do is create a query and add the affected tables in the query builder then switch to SQL view. you should be able to see the joins from there.

Upvotes: 1

Related Questions