The deptype column in sysdepends

microsoft.public.sqlserver.programming

1 Sep 2005 3:49 PM

Saffron

Could someone please provide me with an explanation of the different
deptype values for the sysdepends table.

The column isn't listed in the MSDN Transact-SQL Reference for SQL
Server 2000 and a search hasn't provided me with the answer either.

Thanks.

-- Saffron

1 Sep 2005 4:25 PM

John Bell

Hi

It seems that
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys-d_0xdf.asp or the January 2004 BOL is not up-to-date.

According to "Inside SQL Server 2000" by Kalen Delaney ISBN 0-7356-0998-5
(P625) deptype indicates whether the dependency os schema-bound.

John

Show quote

"Saffron" wrote:

> Could someone please provide me with an explanation of the different
> deptype values for the sysdepends table.
>
> The column isn't listed in the MSDN Transact-SQL Reference for SQL
> Server 2000 and a search hasn't provided me with the answer either.
>
> Thanks.
>
> -- Saffron
>
>