如何在视图中添加新列？

ALTER TABLE table_name ADD COLUMN new_column_name data_type;

ALTER TABLE table_name ADD COLUMN new_column_name data_type;

ALTER TABLE table_name ADD new_column_name data_type;

ALTER TABLE table_name ADD (new_column_name data_type);

BEGIN TRANSACTION;

CREATE TABLE new_table_name AS SELECT * FROM table_name;
ALTER TABLE new_table_name ADD COLUMN new_column_name data_type;

DROP TABLE table_name;

ALTER TABLE new_table_name RENAME TO table_name;

COMMIT;

-- MySQL/MariaDB/PostgreSQL/SQL Server
ALTER TABLE users ADD COLUMN age INT;

-- Oracle
ALTER TABLE users ADD (age INT);

-- SQLite
BEGIN TRANSACTION;

CREATE TABLE new_users AS SELECT * FROM users;
ALTER TABLE new_users ADD COLUMN age INT;

DROP TABLE users;

ALTER TABLE new_users RENAME TO users;

COMMIT;