Why does the SystemTable "dtProperties" show up as UserTable

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Why does the SystemTable "dtProperties" show up as UserTable

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-08-16 : 08:08:17

Corbin writes "There is a SystemTable called dtproperties. SQL Server Enterprise Manager shows it as a system table.

So why then when I use the SQL statement below does it show up?

SELECT *
FROM sysobjects o
WHERE OBJECTPROPERTY(o.id, 'IsSystemTable') = 0
AND OBJECTPROPERTY(o.id, 'IsTable') = 1

Is there something wrong with my IsSystemTable logic?"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-08-16 : 08:09:35

Enterprise Manager uses a different method for identifying a system object than OBJECTPROPERTY does. See what results you get with this:

SELECT *
FROM sysobjects o
WHERE OBJECTPROPERTY(o.id, 'IsMSShipped') = 1
AND OBJECTPROPERTY(o.id, 'IsTable') = 1

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-16 : 09:08:42

Information_Schema.tables will have only non-system tables and views
As you can see dtproperties, it is a non-system table

select table_name from information_Schema.tables where table_type='base table'

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources