Hi,
I'd like to know if there is the possibility to obtain the schema of temporary tables via ODBC.
For standard tables, it's possible using the command
Code:
Conn.GetSchema ("Columns", {Nothing, Nothing, TableName})
Into SQLServer exists the same command for standard tables and the following trick for temporary tables:
Code:
Conn.CreateRecordSet ("DECLARE @table_name As VARCHAR(300)" &
"SET @table_name = (SELECT TOP 1 [name] FROM tempdb..sysobjects" &
" WHERE name LIKE '#Foo%')" &
"EXEC tempdb..sp_columns @table_name")
There is something like this into Informix too?
Thanks
dBforums
>
Getting schema of temporary tables
12-02-10, 10:23
Getting schema of temporary tables
Linear Mode
