dtproperties

what is the significance of dtproperties tables
Giri
Is hold the "extended properties" information. Read about it in Books Online for information about
what "extended properties" is.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message
news:06ba01c49fa6$dc6cc580$a601280a@.phx.gbl...
> what is the significance of dtproperties tables
> Giri
|||Giri,
It is an MS supplied table so although it is shown as a User table, it
in fact isn't. This can bite you if you write scripts that look at the
SystemTable property. A better one to use if you're looking for all
system tables, or all user tables is to use IsMsShipped.
ie.
select * from sysobjects
where objectproperty (id, 'IsMsShipped') = 0
will show you all objects in the current database that MS didn't ship.
(i.e. ones you created). Notice that dtproperties is not here.
However if you run:
select * from sysobjects
where objectproperty (id, 'IsSystemTable') = 0
and name = 'dtproperties'
You get one row back.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
anonymous@.discussions.microsoft.com wrote:
> what is the significance of dtproperties tables
> Giri
|||Thanks Mark..Ofcourse it was killing me on conversion
scripts...I am using information_schema.columns view to
find out some meta info...I had no other option than to
filter out by not in ('dtproperties').
Giri
>--Original Message--
>Giri,
>It is an MS supplied table so although it is shown as a
User table, it
>in fact isn't. This can bite you if you write scripts
that look at the
>SystemTable property. A better one to use if you're
looking for all
>system tables, or all user tables is to use IsMsShipped.
>ie.
>select * from sysobjects
>where objectproperty (id, 'IsMsShipped') = 0
>will show you all objects in the current database that MS
didn't ship.
>(i.e. ones you created). Notice that dtproperties is not
here.
>However if you run:
>select * from sysobjects
>where objectproperty (id, 'IsSystemTable') = 0
>and name = 'dtproperties'
>You get one row back.
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602m.html
>
>anonymous@.discussions.microsoft.com wrote:
>.
>