SQL: Data Types
more>>>>>
The following is a list of general SQL datatypes that may not be supported by all relational databases.
Data Type | Syntax | Explanation (if applicable) |
integer | integer | |
smallint | smallint | |
numeric | numeric(p,s) | Where p is a precision value; s is a scale value. For example, numeric(6,2) is a number that has 4 digits before the decimal and 2 digits after the decimal. |
decimal | decimal(p,s) | Where p is a precision value; s is a scale value. |
real | real | Single-precision floating point number |
double precision | double precision | Double-precision floating point number |
more>>>>>
No comments:
Post a Comment