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

Linked tables

Hi,
Does anyone know how i can link tables in an SQL DB to an etxernal database,
just like in MS Access?
Many thanks in advance for any assistance
You don't link tables per se. What you do is to set up the remote server as a "linked Server" Read
more about the concept in Books Online, where you find how to do it with SQL commands as well as
through the GUI.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Marek" <Marek@.discussions.microsoft.com> wrote in message
news:81955741-5D1F-4CDB-8ED5-7764B9A89D0C@.microsoft.com...
> Hi,
> Does anyone know how i can link tables in an SQL DB to an etxernal database,
> just like in MS Access?
> --
> Many thanks in advance for any assistance

Linked tables

Hi,
Does anyone know how i can link tables in an SQL DB to an etxernal database,
just like in MS Access?
--
Many thanks in advance for any assistanceYou don't link tables per se. What you do is to set up the remote server as a "linked Server" Read
more about the concept in Books Online, where you find how to do it with SQL commands as well as
through the GUI.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Marek" <Marek@.discussions.microsoft.com> wrote in message
news:81955741-5D1F-4CDB-8ED5-7764B9A89D0C@.microsoft.com...
> Hi,
> Does anyone know how i can link tables in an SQL DB to an etxernal database,
> just like in MS Access?
> --
> Many thanks in advance for any assistance

Linked tables

Hi,
Does anyone know how i can link tables in an SQL DB to an etxernal database,
just like in MS Access?
--
Many thanks in advance for any assistanceYou don't link tables per se. What you do is to set up the remote server as
a "linked Server" Read
more about the concept in Books Online, where you find how to do it with SQL
commands as well as
through the GUI.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Marek" <Marek@.discussions.microsoft.com> wrote in message
news:81955741-5D1F-4CDB-8ED5-7764B9A89D0C@.microsoft.com...
> Hi,
> Does anyone know how i can link tables in an SQL DB to an etxernal databas
e,
> just like in MS Access?
> --
> Many thanks in advance for any assistance