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,change table fileformat from orc to parquet is not supported?

I have a hive table like this: CREATE TABLE `abtestmsg_orc`( `eventname` string COMMENT 'AB测试方案上报事件:ABTest', `eventtime` string COMMENT '事件上报时间…

hive alter-table parquet orc
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 …

sql sql-server stored-procedures alter-table sql-view
Add constraint to existing SQLite table

I'm using SQLite, which doesn't support adding a constraint to an existing table. So I can't do something like this (…

sqlite database-schema entity-framework-core alter-table check-constraints