Toad World® Forums

system objects


#1

Hi,

I cannot find all system tables in Object Explorer:

Query shows that there shall be 58 records, but in OE there is a little bit
less.

Butter

int_1.jpeg
int_1.jpeg


#2

Hi Marcin,

That is correct. We do the same as Management Studio and we agree that this is
reasonable. We use this query:

select * from master.sys.objects where [type] = 'U ’

and is_ms_shipped = 1

regards,

Alexander Maximov
int_1.jpeg


#3

Hi Marcin,

That is correct. We do the same as Management Studio and we agree that this is
reasonable. We use this query:

select * from master.sys.objects where [type] = 'U ’

and is_ms_shipped = 1

regards,

Alexander Maximov
image001.jpeg


#4

Hi Marcin,
That is correct. We do the same as Management Studio and we agree that this is
reasonable. We use this query:
select * from master.sys.objects where [type] = 'U ’
and is_ms_shipped = 1
[…]

Alexander,
imho it is wrong approach. There is an option ‘show system objects’ [see
previous post] to show / hide
such objects.


Butter


#5

Marcin,

Would you please let me know what for you need system objects to be shown in Object Explorer?


#6

[…]
Marcin, Would you please let me know what for you need system objects to be
shown in Object Explorer?
[…] .,__

Valentine,
I very often query against system objects - maybe not on master db, but on
‘production’ db.
Sys objects holds a lot of usefull metadata.
When they are visible in OE it would be easier to filter data, to drag to
editor.

As I mentioned before - you can [;)] hide s.o. by default, but allow user to
turn them on.
[I’m also able to handle situation, where I have no access to this objects]

Butter


#7

Valentine please consider Data type, Null, Primary and FK, creationdate,
modification date…

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image001.gif


#8

Valentine please consider Data type, Null, Primary and FK, creationdate,
modification date…

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image002.jpeg


#9

Hi everybody,

Seems like I misunderstand something here. First of all, all system objects are
accessible in the Object Explorer. All but system tables in versions of SQL
Server later than 2000 (2005+). Are we talking about showing system tables
(not system views!) in the Object Explorer for SQL Server 2005+? About those
tables that are accessible only through DAC and whose information is generally
available via system views?

Thanks,

Igor.
image002.jpeg


#10

Hi everybody,

Seems like I misunderstand something here. First of all, all system objects are
accessible in the Object Explorer. All but system tables in versions of SQL
Server later than 2000 (2005+). Are we talking about showing system tables
(not system views!) in the Object Explorer for SQL Server 2005+? About those
tables that are accessible only through DAC and whose information is generally
available via system views?

Thanks,

Igor.
image001.gif


#11

Hi everybody,

Seems like I misunderstand something here. First of all, all system objects are
accessible in the Object Explorer. All but system tables in versions of SQL
Server later than 2000 (2005+). Are we talking about showing system tables (not
system views!) in the Object Explorer for SQL Server 2005+? About those tables
that are accessible only through DAC and whose information is generally
available via system views?

[…]

Igor,

you are right, my fault.

Really I’ve been talking about views [but called them system objects]

Butter