Ryan,
This works on SQL Server 2000. You can get a specific
table or set it up to look through them dynamically.
select O.name, C.name from sysobjects O
join syscolumns C ON C.id = O.id
where O.xtype = 'U'
and O.name = 'your table name here'
order by C.colorder
Good luck!
Chris
--- Ryan Hartwich <[EMAIL PROTECTED]>
wrote:
> Bryan & Chris,
>
> You have given us great insight into finding table &
> column names in Access.
> Do you have a way in SQL Server? I tried looking at
> some of the sysobjects
> type tables but they are pretty heavily populated
> with strange data.
>
> Ryan
>
>
>
>
______________________________________________________________________
> The KCFusion.org list and website is hosted by
> Humankind Systems, Inc.
> List Archives........
> http://www.mail-archive.com/cf-list@kcfusion.org
> Questions, Comments or Glowing Praise..
> mailto:[EMAIL PROTECTED]
> To Subscribe....................
> mailto:[EMAIL PROTECTED]
> To Unsubscribe................
> mailto:[EMAIL PROTECTED]
>
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
