FireBird: ALTER COLUMN <column> TYPE <type> DB2: ALTER COLUMN <column> SET DATA TYPE <type>. Oracle: MODIFY <column> <type> MSSQL: ALTER COLUMN <column> <type> <constraints> MySQL: Both Oracle and MSSQL Sap: MODIFY <column> <type>
Given that, I'm happy with what we got ...
Yeah same, I was just wondering whether it should be like SET NOT NULL, that's all.
Chris
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend