Top "Alter-table" questions

The "ALTER TABLE" is a SQL statement that allows you to make schema changes to a database table (i.e. add, drop or alter columns from an existing table).

Hive Alter table change Column Name

I am trying to rename a columnName in Hive. Is there a way to rename column name in Hive . tableA (…

hive alter-table alter
How to add a boolean datatype column to an existing table in sql?

I have a table called person in my database. I want to add another column to the same table and …

sql sql-server alter-table
ALTER TABLE ADD COLUMN IF NOT EXISTS in SQLite

We've recently had the need to add columns to a few of our existing SQLite database tables. This can be …

sqlite alter-table
How do I Alter Table Column datatype on more than 1 column?

For example: ALTER TABLE webstore.Store MODIFY COLUMN ( ShortName VARCHAR(100), UrlShort VARCHAR(100) ); The above however does not work. I am …

mysql alter-table
Modify a Column's Type in sqlite3

I'm pretty new to SQLite 3 and just now I had to add a column to an existing table I had. …

sqlite alter-table
How to add a column in TSQL after a specific column?

I have a table: MyTable ID FieldA FieldB I want to alter the table and add a column so it …

tsql alter-table
ALTER TABLE without locking the table?

When doing an ALTER TABLE statement in MySQL, the whole table is read-locked (allowing concurrent reads, but prohibiting concurrent writes) …

sql mysql ddl alter-table
Adding a column as a foreign key gives ERROR column referenced in foreign key constraint does not exist

I have the following set up, CREATE TABLE auth_user ( id int PRIMARY KEY ); CREATE TABLE links_chatpicmessage (); I'm trying …

database postgresql foreign-keys alter-table
SQL alter column datatype from nvarchar to int

Can the datatype of a field be changed to int from nvarchar?? alter table employee alter column designation int is …

sql-server type-conversion alter-table
Best way to add column with default value while under load

When adding a column to a table that has a default value and a constraint of not null. Is it …

oracle alter-table