General information
Forum:
Microsoft SQL Server
Title:
Verify a TempTable using VFP on SQLServer2000
I've the need to create a TempTable in SQL server, if that TempTable doesn't exist yet.
I can create it with:
SQLEXEC(lnActiveConnection,"create table #TempQuery ID char(36) PRIMARY KEY)")
but I can't verify its existence neither with:
SQLEXEC(lnActiveConnection,"EXEC sp_tables @table_name = '#TempQuery';")
(the statement return 0 records) nor with:
SQLEXEC(lnActiveConnection,"EXEC sp_tables @table_name = '#TempQuery', @table_owner = 'dbo', @table_qualifier = 'tempdb';")
(this statement return -1).
How to get the information?
TIA
Bruno Maddalozzo
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only