Hello all
What is the best way to go about coming up with a script that builds the schema out of the existing database?
In detail ,
1. I have an existing database with live data.
2. I want to create a schema copy of the existing db in step 1. Just the structure with all the objects in it ( tables,views,constraints etc ..the list goes on ).
What are the options I need to explore and the best way to go about it ?
Thanks in advance