Some modelling tools allow me to set an attribute data type to Boolean - a choice of True or False. I can't see an obvious data type to use in the ER/Studio LDM - any suggestions?
I think the answer is to use the BIT data type, though I would never have guessed it myself. Here's what Wikipedia says about it:
BIT - The BIT data type, which can only store integers 0 and 1 apart from NULL
I suspect that's fine in a PDM (I don't profess to be an expert on DBMS data types), but there ought to be a more obvious data type in the LDM, such as BOOLEAN.
Powered by IDERA