The xp_gettable_odbc extended stored procedure (in Xp_odbc.dll) uses ODBC to open a bound connection to the same Microsoft® SQL Server™ that called the extended stored procedure. The server returns a result set to the extended stored procedure, which passes the result set to the client, for example:
DECLARE @tablename varchar(25)
SELECT @tablename = 'pubs..authors'
EXECUTE xp_gettable_odbc @tablename
This is in a sample only available if you select Dev Tools during setup.
xp_gettable_odbc works only on SQL Server running on Microsoft Windows NT®.