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
|