alter-table Examples and Free Source Code

ALTER TABLE in Postgres with a subquery...

postgresql subquery alter-table

Will changing column from timestamp to timestamptz lock the table?...

postgresql concurrency timestamp postgresql-9.3 alter-table

Change column type from timestamp WITHOUT time zone to timestamp WITH time zone...

sql postgresql timezone ddl alter-table

How do I set the DEFAULT value for a non-nullable column to the TOP 1 result of a SELECT query?...

sql sql-server alter-table

Creating a data model from scratch: Adding a Foreign Key in PostgreSQL...

postgresql foreign-keys etl data-modeling alter-table

MySQL: ALTER IGNORE TABLE ADD UNIQUE, what will be truncated?...

mysql alter-table unique-key

`MODIFY COLUMN` vs `CHANGE COLUMN`...

mysql alter-table

Postgresql - change the size of a varchar column to lower length...

sql postgresql varchar alter-table

Modify a Column's Type in sqlite3...

sqlite alter-table

Does adding a null column to a postgres table cause a lock?...

postgresql alter-table

How do I alter the position of a column in a PostgreSQL database table?...

sql database postgresql alter-table

Can I prepare "ALTER TABLE ? RENAME TO ?;" in SQLite?...

sqlite prepared-statement alter-table

MySQL very slow for alter table query...

mysql sql alter-table

Oracle ALTER TABLE MOVE INCLUDING ROWS not working properly...

oracle alter-table

How to alter a table using mongodb...

mongodb mongodb-query insert-update alter-table

ALTER TABLE ADD CONSTRAINT gets Error 1064...

mysql sql ddl alter-table

PostgreSQL: what's the difference between "alter table ... add unique (...)" and &quot...

sql postgresql constraints unique alter-table

Adding an identity to an existing column...

sql sql-server alter-table identity-column

Alter column type from text[] to jsonb[]...

arrays postgresql jsonb ddl alter-table

Alter column type with non-trivial usage of "using" clause...

postgresql using alter-table

Is there any way to list all the views related to a table in the existing postgres schema...

postgresql function view alter-table database-optimization

How to change the description of a field nested in a struct via the DDL in BigQuery?...

sql google-bigquery ddl alter-table

SQL Server add auto increment primary key to existing table...

sql-server sql-server-2008 primary-key alter-table

ALTER TABLE WITH SELECT...

sql postgresql alter-table

Altering column data type...

sql oracle alter-table

How to alter a column's data type in a PostgreSQL table?...

sql postgresql psql alter-table alter-column

Problem with Postgres ALTER TABLE...

postgresql dependencies alter-table

Unanticipated Index Creation in MSSQL and its Impact on Column Alteration - INDEX_VV_<3to4DigitNu...

sql-server indexing alter-table alter

How do you change the datatype of a column in SQL Server?...

sql-server t-sql type-conversion alter-table

Change a Nullable column to NOT NULL with Default Value...

sql sql-server default-value alter-table alter-column