I posted this in the Nerdery, but with it being a fairly simple question, I figured I might get an answer here since there is more traffic.

I've imported an access database into SQL Server Management Studio. Everything works great, but I would like to see the code behind the SQL database (Essentially the code that SQL used to create the tables/relationships). Is there an easy way to find this, or am I SOL?

There's an easy way.

Step 1: post tits

It's been a dozen years since I've done any IT related work, but I believe what you are looking for is the DML (Data Management Language), used to construct the tables, not SQL (System Query Language). I don't know how to get to the ACCESS DML, but this might help in your searching.

1. Right click table
2. Script table as
3. ...
4. Profit

Or

http://blogs.msdn.com/b/davidlean/archive/2009/09/20/tip-ssms-script-your-entire-table-including-the-data-a-hidden-gem.aspx

[This message has been edited by Tibbles (edited 10/15/2012 6:41a).]

Just what I needed. Thanks!