do not display system views - connection via Excel
- From: christophe.leroquais@xxxxxxxxx
- Date: 30 May 2006 07:24:32 -0700
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
.
- Prev by Date: Re: SQL 2005 Express-Database does not have a valid owner?
- Next by Date: Re: SQL 2005 Express-Database does not have a valid owner?
- Previous by thread: SQL Server (2005 or other) - Permissions on Views Excel Connection
- Next by thread: Re: Can't created a linked server on a named instance to default insta
- Index(es):
Relevant Pages
|