Do you mean altering the table after it has been created? If so you need to use alter table, in particular: ALTER TABLE tablename MODIFY COLUMN new-column-definition e.g. ALTER TABLE test MODIFY COLUMN locationExpect VARCHAR(120);
“Alter column position” in the PostgreSQL Wiki says: PostgreSQL currently defines column order based on the attnum column of the pg_attribute table. The only way to change column order is either by recreating the table, or by adding columns and rotating data until you reach the desired layout. That’s pretty weak, but in their defense, … Read more
No, you have to add them one at a time. See the syntax diagram at the top of SQLite’s ALTER TABLE documentation: There’s no loop in the ADD branch so no repetition is allowed.
Just use an ALTER TABLE… MODIFY… query and add NOT NULL into your existing column definition. For example: ALTER TABLE Person MODIFY P_Id INT(11) NOT NULL; A word of caution: you need to specify the full column definition again when using a MODIFY query. If your column has, for example, a DEFAULT value, or a … Read more
This should work: ALTER TABLE t_tableName ADD newColumn VARCHAR(50) CONSTRAINT YourContraintName DEFAULT ” NOT NULL
Try this alter table TableName add constraint df_ConstraintNAme default getutcdate() for [Date] example create table bla (id int) alter table bla add constraint dt_bla default 1 for id insert bla default values select * from bla also make sure you name the default constraint..it will be a pain in the neck to drop it later … Read more
In PostgreSQL 9.1 there is an easier way http://www.postgresql.org/message-id/162867790801110710g3c686010qcdd852e721e7a559@mail.gmail.com CREATE TABLE foog(a varchar(10)); ALTER TABLE foog ALTER COLUMN a TYPE varchar(30); postgres=# \d foog Table “public.foog” Column | Type | Modifiers ——–+———————–+———– a | character varying(30) |
ALTER TABLE `table_name` MODIFY COLUMN `column_name2` enum( ‘existing_value1’, ‘existing_value2’, ‘new_value1’, ‘new_value2’ ) NOT NULL AFTER `column_name1`;
See documentation here: http://www.postgresql.org/docs/current/interactive/sql-altertable.html ALTER TABLE tbl_name ALTER COLUMN col_name TYPE varchar (11);
ALTER TABLE provider ADD PRIMARY KEY(person,place,thing); If a primary key already exists then you want to do this ALTER TABLE provider DROP PRIMARY KEY, ADD PRIMARY KEY(person, place, thing);