October 28, 2005 at 7:10 am
Hi all. I have have been tasked with creating a data definition of a databse and having never done anything like this need as much help as is out there.
How ever small the offering please let me have it.
Taff
October 28, 2005 at 7:47 am
In EM under the database tab right click on the appropriate database and select 'all tasks' --> 'Generate SQL script' and from there you will be able to script the database, objects, and permissions.
October 28, 2005 at 9:55 am
Kory's method should give you what you need. In addition, you could use the diagramming functionality to provide some of this same information in a graphical format which could assist in understanding relationships between the tables which may not be quite as intuitive when looking at the scripts. It is not a replacement to having the scripts however.
Just thought I'd throw that out there in case you weren't aware of it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply