Differences

This shows you the differences between two versions of the page.

oracle:all_tables [July 06, 2012 5:51 am]
sqlines
oracle:all_tables [July 06, 2012 7:44 am] (current)
sqlines
Line 92: Line 92:
  SET @sql = SUBSTRING(@sql, 1, LEN(@sql) - 10);   SET @sql = SUBSTRING(@sql, 1, LEN(@sql) - 10);
-  -- Execute the query+  -- Execute the query (returns all tables in all databases as a single result set)
  EXEC sp_executesql @sql;   EXEC sp_executesql @sql;
  GO   GO