Complete Data Type List Flashcards
1
Q
Bit
A
0 or 1
2
Q
TinyInt
A
1 byte
3
Q
SmallInt
A
2 bytes
4
Q
Int
A
4 bytes
5
Q
BigInt
A
8 bytes
6
Q
Numeric
A
Varies
7
Q
Decimal
A
Varies
8
Q
SmallMoney
A
4 bytes
9
Q
Money
A
8 bytes
10
Q
DateTime
A
8 bytes
11
Q
SmallDateTime
A
4 bytes
12
Q
Date
A
3 bytes
13
Q
Time
A
5 bytes
14
Q
DateTimeOffset
A
10 bytes
15
Q
DateTime2
A
Varies
16
Q
Char
A
Varies
17
Q
VarChar (MAX)
A
BLOB
18
Q
nChar
A
Varies
19
Q
nVarChar
A
Varies
20
Q
nVarChar (MAX)
A
BLOB
21
Q
Binary
A
Varies
22
Q
VarBinary
A
Varies
23
Q
Image
A
BLOB
24
Q
Uniqueidentifier
A
16 bytes
25
Q
1NF
A
Eliminate Repeating Groups
26
Q
2NF
A
Eliminate Redundant Data
27
Q
3NF
A
Eliminate Non-Dependent Columns
28
Q
4NF
A
No Independent Multiple Relationships
29
Q
5NF
A
Isolate Semantically Related Relationships
