dtproperties

what is the significance of dtproperties tables
GiriIs 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:
>> what is the significance of dtproperties tables
>> Giri
>.
>