Document Table Structure

[yamafopa]

Hi there

New to SQL - moving from Access. Have gotten pretty used to the handy Access documenter which produces customizable listings of your database objects, properties etc. I have not been able to locate something similar in SQL tools. Wishful thinking, stupid question or what???

thanks
yamafopa!

 

[SQLSister]

You can script the objects in your database. Right click on an object in Enterprise Manager, go to All tasks and choose Generate SQL Script.

 

[yamafopa]

Yeah

A little harder to read, but I suppose it's good enough...

Thanks!