do not display system views - connection via Excel

do not display system views - connection via Excel

Post by christophe » Wed, 31 May 2006 23:23:24


Hello,

In excel, when I use GetExternalData Tool, I can access all the system
tables as listed below:

all_columns
all_objects
all_parameters
all_sql_modules
all_views
allocation_units
assemblies
assembly_files
assembly_modules
assembly_references
....etc...
.....
xml_schema_wildcards

I do not want to get this list as it is useless and It's hard to find
my views in this list.

I would like to get the list of the only Views I have created.

Do you know how to do that?

help much appreciated.

Chris