Hi,
say I have a column in a table PERSON defined as
NAME VARCHAR(100) NOT NULL
and want to redefine it to
NAME VARCHAR(100)
since this means relaxing the requirements, I would assume that it should work even when data is in the table.
I tried
ALTER TABLE PERSON MODIFY(NAME VARCHAR(100))
which did not change anything and did not give an error message
Then I tried updating the definition of the column using SQLStudio which allowed me to perform the exact same manipulation using the GUI.
Now my question is, what exactly happens behind the scenes when I use SQLStudio for that purpose. Is it doing something I can also do manually using SQL?
Thanks,
Robert
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
