-- AccessDB Rescue (accessdbrescue.eu): structure of this SQL Server database. Read-only, reads no data. -- Returns one row per table, view, procedure, function, trigger and foreign key, with row counts and code size. -- Run it in the database of your application (SQL Server 2008 or newer), then save the result as CSV -- (right-click the result grid > Save Results As...) and add that file to the scan. SET NOCOUNT ON; SELECT 'database' AS object_type, '' AS schema_name, DB_NAME() AS object_name, NULL AS row_count, NULL AS column_count, NULL AS has_pk, REPLACE(REPLACE(LEFT(@@VERSION, CHARINDEX(CHAR(10), @@VERSION + CHAR(10)) - 1), CHAR(13), ''), ',', ' ') AS ref_name, NULL AS code_lines UNION ALL SELECT 'table', s.name, t.name, (SELECT SUM(p.rows) FROM sys.partitions p WHERE p.object_id = t.object_id AND p.index_id IN (0, 1)), (SELECT COUNT(*) FROM sys.columns c WHERE c.object_id = t.object_id), CASE WHEN EXISTS (SELECT 1 FROM sys.key_constraints k WHERE k.parent_object_id = t.object_id AND k.type = 'PK') THEN 1 ELSE 0 END, NULL, NULL FROM sys.tables t JOIN sys.schemas s ON s.schema_id = t.schema_id WHERE t.is_ms_shipped = 0 UNION ALL SELECT CASE o.type WHEN 'V' THEN 'view' WHEN 'P' THEN 'procedure' WHEN 'TR' THEN 'trigger' ELSE 'function' END, s.name, o.name, NULL, NULL, NULL, NULL, LEN(m.definition) - LEN(REPLACE(m.definition, CHAR(10), '')) + 1 FROM sys.objects o JOIN sys.schemas s ON s.schema_id = o.schema_id LEFT JOIN sys.sql_modules m ON m.object_id = o.object_id WHERE o.is_ms_shipped = 0 AND o.type IN ('V', 'P', 'FN', 'IF', 'TF', 'TR') UNION ALL SELECT 'foreign_key', s.name, OBJECT_NAME(f.parent_object_id), NULL, NULL, NULL, OBJECT_NAME(f.referenced_object_id), NULL FROM sys.foreign_keys f JOIN sys.schemas s ON s.schema_id = f.schema_id ORDER BY 1, 2, 3;