Ok, I would like to ask you this if I may,
On another database I created a table named FICTION
and the table looks like this:
CREATE TABLE FICTION
(BOOK_CODE CHAR(4) PRIMARY KEY,
TITLE CHAR(40),
PUBLISHER_CODE CHAR(3),
PRICE DECIMAL(4,2) );
Now I am trying to change the data type in TITLE to CHAR(50)
ALTER
TABLE FICTION
MODIFY
COLUMN TITLE
View Complete Post