Retorna todas as tabelas de um banco do sqlserver
1 2 3 4 5 6 7 8 9 10 11 |
CREATE TABLE #tabela_banco( [TABLE_QUALIFIER] [varchar](500) NULL, [TABLE_OWNER] [varchar](500) NULL, [TABLE_NAME] [varchar](500) NULL, [TABLE_TYPE] [varchar](500) NULL, [REMARKS] [varchar](500) NULL ) ON [PRIMARY] insert INTO #tabela_banco EXEC sp_tables SELECT * FROM #tabela_banco WHERE TABLE_TYPE = 'table' |