Profile Rank Details Published Articles Codes

SQLite

SELECT name FROM sqlite_master
WHERE type='table'
ORDER BY name

MS SQl
select distinct name from sysobjects where xtype='U'

MySQL
SELECT * 
FROM information_schema.tables

Oracle
select * from tab

this is the needed query to get table names from database for each engine for Sqlite,MS Sql,mysql ,Oracle this can be useful when you hack

Category: SQL