Home > Archive > Microsoft SQL Server forum > August 2005 > Table structure of Linked server









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Table structure of Linked server
c

2005-08-02, 9:23 am

Hello!

Does anybody know how to get tables structure of linked server (DBF tables
via ODBC connection). I know that table structure of "normal" (not linked)
server can get from systables and syscolumns tables, but now I need a
structure of linked server tables.

Thanks!


Simon Hayes

2005-08-02, 11:24 am

See sp_tables_ex and sp_columns_ex in Books Online. An alternative
might be to use OPENQUERY() to pass through a query which queries the
DBF metadata natively, but I have no idea if that's possible or even
makes sense for DBF files.

Simon

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com