SQLFacts - AdventureWorks2019
Fact Rows Name
01 1 Filegroups
02 2 Database Files
03 2 Database Users
04 6 Schemas
05 0 Schema Permissions
06 71 Table Details, by name
07 71 Table Details, by row count
08 0 Partitions (Table)
09 0 Partitions (Index)
10 71 Primary Keys
11 1 Alternate Keys
12 103 Indexes
13 90 Foreign Keys
14 89 Check Constraints
15 10 Triggers
16 486 Table Columns
17 263 Routine Columns
18 41 Routine Parameters
19 0 Table/Routine Permissions
20 0 Sequences
21 0 Synonyms
22 26 External References
23 152 Internal References, by object caller
24 152 Internal References, by object called
25 71 Table Summary, by name
26 71 Table Summary, by layer
27 71 Table Summary, by estimate
28 51 Routine Summary, by name
29 51 Routine Summary, by layer
30 51 Routine Summary, by estimate
31 20 Data Type Analysis (Primary Keys)
32 76 Data Type Analysis (Table Columns)
33 13 Data Type Analysis (Routine Parameters)
34 241 Name Analysis (Table Columns)
35 25 Name Analysis (Routine Parameters)
36 111 Foreign Keys To Consider
37 90 Foreign Key Indexes
38 2 Index Redundancy
39 10 Questionable Indexes
40 1 Questionable Tables
41 0 Questionable Foreign Keys
42 0 Questionable Constraints
43 0 Questionable Defaults
44 10 Questionable Routines
45 0 Questionable Data Types
46 36 Questionable Names
47 3 Questionable Parameters
48 0 Questionable Objects
49 23 Questionable References