dtproperties Table in SQL Server 2000 | SansSQL

Friday, June 6, 2008

dtproperties Table in SQL Server 2000

dtproperties is a system table that stores the information about the Database Diagrams created in a particular database. Whenever a Database diagram is created or modified this table
gets updated automatically.

Basically this is a system table but when we run the below query we will get the name of
dtproperties table in the result set, indicating that this is user table.Microsoft has
confirmed that this is a bug in the Microsoft SQL Server.

Select * from sysobjects where xtype='u'