Le 10/10/2012 10:47, Vineet Deodhar a écrit :
> Hi !
>
> 3) Can I simulate MySQL's TINYINT data-type (using maybe the custom data
> type or something else)
>
Another way, and a good practice toot is to use SQL DOMAINs wich is a
part of the ISO SQL since 1992 that MySQL don't have...
CREATE DOMAIN TINYINT
AS SMALLINT
CHECK (VALUE BETWEEN 0 AND 255)
Most part of the modelling tools are able to use DOMAINs in their
modelling process, like PowerDesigner, Mega, ERwin, Rational...
A +
--
Frédéric BROUARD - expert SGBDR et SQL - MVP SQL Server - 06 11 86 40 66
Le site sur le langage SQL et les SGBDR : http://sqlpro.developpez.com
Enseignant Arts & Métiers PACA, ISEN Toulon et CESI/EXIA Aix en Provence
Audit, conseil, expertise, formation, modélisation, tuning, optimisation
*********************** http://www.sqlspot.com *************************
