Rename column name of a table using Alter statement.

 Rename column name of a table using Alter statement.

-- create a table DDL

CREATE TABLE students (

  id INTEGER primary key,

  name TEXT ,

  gender TEXT

);

-- insert some values

INSERT INTO students VALUES (1, 'Ryan', 'M');

INSERT INTO students VALUES (2, 'Joanna', 'F');

ALTER TABLE students RENAME COLUMN name TO student_name;

SELECT id, student_name, gender  FROM students;

1|Ryan|M
2|Joanna|F