Top "Alter" questions

Alter column length in Schema builder?

I have two fields i need to increment the character limit on. I're read through the documentation and to my …

database schema builder laravel alter

MySQL ALTER TABLE on very large table - is it safe to run it?

I have a MySQL database with a MyISAM table with 4 million rows. I update this table about once a week …

mysql primary-key alter

MySQL alter table - changing a TINYINT to a SMALLINT

I have the following database with two tables (excuse my ugly format): TABLE_A : Id TINYINT, PRIMARY KEY (Id) TABLE_…

mysql key alter sql-types

rename sequence in other schema with same currval

I need to rename bunch of sequences in another schema. RENAME old_seq to new_seq doesnt work. Tried: ALTER …

sql sequence rename alter nextval

remove ON DELETE CASCADE

I have a child table. and foreign key there with ON DELETE CASCADE while creating the table. There are no …

sql constraints cascade alter

Add a column to a table with check constraint SQL

I want to add a column to a table, then add a check constraint to make sure its greater than 0. …

sql oracle11g constraints alter

MYSQL 5.5 Drop Primary Key

I am upgrading my quartz.net version from 1.0.3 to 2.0.2 There is a migration script for database schema, which was was …

mysql sql quartz.net alter

How to undo ALTER TABLE using sqlplus (Oracle 10g Express)?

rollback; doesn't seem to undo alter table changes. Background: I'm generating some .sql scripts (based on parsed Hibernate scripts) which …

oracle10g sqlplus rollback alter

Change column name without recreating the MySQL table

Is there a way to rename a column on an InnoDB table without a major alter? The table is pretty …

mysql alter

MySQL Alter table, add column with unique random value

I have a table that I added a column called phone - the table also has an id set as …

mysql alter