-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07/16/2015 02:46 PM, Hayden Livingston wrote: > It seems that > > CREATE TABLE A( something varchar(255) ) > > it just > > CREATE TABLE A( something text ) > > Why have it at all?
Because other code and other humans look at the database too. Consider it documentation of intent. If it has no value to you, then leave out the type. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iEYEARECAAYFAlWoJyIACgkQmOOfHg372QTu+wCghdSY6eDO5zXezGV+/xRXHHDr rWUAn1XuuG65S/48qjyfx9TP/lzXYS0g =Fzkn -----END PGP SIGNATURE-----