Current location - Training Enrollment Network - Books and materials - There are several types of fields in database tables.
There are several types of fields in database tables.
The types of fields in database tables include binary data type, character data type, numerical data type and so on. The specific types are as follows:

1, binary data type

Binary、Varbinary、Image

2. Character data type

Char, Varchar and Text?

3.Unicode data types

Include Nchar, Nvarchar and Ntext.

4. Date and time data types

Include date time, small date time, date and time stamp.

5. What is a digital data type?

Numeric data types include positive and negative numbers, decimals and integers.

6. Currency data type

Represents a positive or negative amount.

7. Special data types

There are three special data types, namely timestamp, bit and unique identifier.