16
Data Types in SQL
•
Characters:
–
CHAR(20)
-- fixed length
–
VARCHAR(40)
-- variable length
•
Numbers:
–
INT, REAL plus variations
•
Times and dates:
–
DATE, DATETIME (SQL Server only)
•
To reuse domains:
CREATE DOMAIN
address
AS
VARCHAR(55)
•