By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (40491 in the last week).
CREATE TABLE people ( id INT GENERATED ALWAYS AS IDENTITY,
firstName VARCHAR(100),
lastName VARCHAR(100),
fullName VARCHAR(200) );
INSERT INTO people (firstName, lastName) VALUES
('firstName1', 'lastName1'),
('firstName2', 'lastName2');
SELECT * FROM people;
✓
2 rows affected
id
firstname
lastname
fullname
1
firstName1
lastName1
2
firstName2
lastName2
…
hidden batch(es)
ALTER TABLE people
DROP COLUMN fullName,
ADD COLUMN fullName VARCHAR(200) GENERATED ALWAYS AS (firstName || ' ' || lastName) STORED;
✓
hidden batch(es)
SELECT * FROM people;
INSERT INTO people (firstName, lastName) VALUES
('firstName3', 'lastName3');
SELECT * FROM people;
UPDATE people SET firstName = firstname || '_changed';
SELECT * FROM people;
