April 16, 2003 at 12:57 pm
I need to run a sql statement to display all schemas from all tables in the database.
Any Ideas?
thanks
April 16, 2003 at 3:07 pm
Do you have to do it from a SQL query? If not, the easiest way is use the script generation facility in Enterprise Manager. And it's easy to pick all or only certain tables.
If you must use SQL, there are a few scripts in the Script Library that will do it, depending on the level of information you want.
Jay Madren
Jay Madren
April 17, 2003 at 10:51 am
When you say schema do you mean just the columns? Or do you need other information?
select * From information_schema.columns should help.
Steve Jones
April 17, 2003 at 1:31 pm
Thanks...works
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply