Linking columns with the table name

Hi Everyone,
Is there a way to read syscolumns and link the column to the table in which
the column resides?
Thanks in advance
Larry
select object_name(id),name from syscolumns
order by object_name(id),colorder
will give you everything in the syscolumns, and the table/sp that it is in.
not sure this is what you want or not.
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:C8FE40BA-274A-4526-B36E-86483D2D683E@.microsoft.com...
> Hi Everyone,
> Is there a way to read syscolumns and link the column to the table in
which
> the column resides?
> Thanks in advance
> Larry
|||Hi Larry
You can look at the code for sp_help to see how that procedure links the
tables together.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:C8FE40BA-274A-4526-B36E-86483D2D683E@.microsoft.com...
> Hi Everyone,
> Is there a way to read syscolumns and link the column to the table in
> which
> the column resides?
> Thanks in advance
> Larry

Linking columns with the table name

Hi Everyone,
Is there a way to read syscolumns and link the column to the table in which
the column resides?
Thanks in advance
Larryselect object_name(id),name from syscolumns
order by object_name(id),colorder
will give you everything in the syscolumns, and the table/sp that it is in.
not sure this is what you want or not.
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:C8FE40BA-274A-4526-B36E-86483D2D683E@.microsoft.com...
> Hi Everyone,
> Is there a way to read syscolumns and link the column to the table in
which
> the column resides?
> Thanks in advance
> Larry|||Hi Larry
You can look at the code for sp_help to see how that procedure links the
tables together.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:C8FE40BA-274A-4526-B36E-86483D2D683E@.microsoft.com...
> Hi Everyone,
> Is there a way to read syscolumns and link the column to the table in
> which
> the column resides?
> Thanks in advance
> Larry