Change a column's definition
ALTER TABLE XXX CHANGE COLNAME COLNAME varchar(10);
ALTER TABLE XXX CHANGE COLNAME COLNAME varchar(50) NOT NULL;
ALTER TABLE XXX CHANGE COLNAME COLNAME varchar(50) NOT NULL;
Add foreign key constraint
ALTER TABLE vsusers ADD FOREIGN KEY (sitenum) REFERENCES vsites (sitenum) ON UPDATE CASCADE ON DELETE RESTRICT;
There are no comments on this page. [Add comment]