SQL Data Type


Prev Tutorial Next Tutorial

Data Type in SQL

In SQL Data Type defines a kind of value that a column can contain.

Data typeSyntax
1IntegerINTEGER
2SmallintSMALLINT
3NumericNUMERIC(P,S)
4RealREAL
5DecimalDECIMAL(P,S)
6FloatFLOAT(P)
7CharacterCHAR(X)
8Character varyingVARCHAR2(X)
9DateDate
10TimeTIME

Note: Data Type varies from database to database. For example, MySQL supports INT but Oracle supports NUMBER for integer values.


Prev Tutorial Next Tutorial

Download Projects

Google Adsense Advertisements
Free Classified Site – Bedpage

Yahoo Advertisements