|
-
how to take Defitions of objects??
Hello All,
I need definitions of all tables, views, functions, store procedures etc... of a particular user..
I mean how can i take all tables, view, functions, store procedures creation scrits....
can any one guide me?
-
you need to get the details of all the tabls,views,..etc related to a specific user ??
or you need to extract the tables,view,procedures owned by a specific user?
-
Lots of ways...
1- Resort to a reverse engineering enabled product like ERWin
2- Query the appropriate system views
3- Export the user with rows=no option then just import it or import it to a file with show=y option
4- Extract the objects using any fancy GUI based product like DBArtisan, etc.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
