tagged [alter]
Postgresql - change the size of a varchar column to lower length
Postgresql - change the size of a varchar column to lower length I have a question about the `ALTER TABLE` command on a really large table (almost 30 millions rows). One of its columns is a `varchar(2...
- Modified
- 2 Sep at 09:31
MySQL: ALTER TABLE if column not exists
MySQL: ALTER TABLE if column not exists I have this code: ``` ALTER TABLE `settings` ADD COLUMN `multi_user` TINYINT(1) NOT NULL DEFAULT 1 ALTER TABLE `settings` ADD COLUMN IF NOT EXISTS `multi_user` ...
- Modified
- 21 Aug at 13:37
How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?
How to DROP multiple columns with a single ALTER TABLE statement in SQL Server? I would like to write a single SQL command to drop multiple columns from a single table in one `ALTER TABLE` statement. ...
- Modified
- 7 Sep at 10:36
Why can't SQL Server alter a view in a stored procedure?
Why can't SQL Server alter a view in a stored procedure? I'm using MS SQL Server, and I'd like to alter a view from within a stored procedure, by executing something like "alter view VIEWNAME as ([som...
- Modified
- 15 Sep at 09:56
add column to mysql table if it does not exist
add column to mysql table if it does not exist My research and experiments haven't yielded an answer yet, so I am hoping for some help. I am modifying the install file of an application which in previ...
- Modified
- 6 Jul at 12:36