SQL Server 2019 (Linux)

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Schools(
[Name] varchar(250),
[Grade] varchar(150),
[City] varchar(150));
INSERT INTO
Schools([Name],[Grade],[City])
VALUES
('Astro School', 'Specialization school', 'Huston'),
('The white beach school', 'High School', 'Honolulu'),
('Queen High School', 'High School', 'London');
3 rows affected

SELECT *
FROM Schools


Name
Grade
City


Astro School
Specialization school
Huston

The white beach school
High School
Honolulu

Queen High School
High School
London


 EXEC sp_RENAME 'Schools.Name' , 'Sign', 'COLUMN'
Caution: Changing any part of an object name could break scripts and stored procedures.


SELECT *
FROM Schools


Sign
Grade
City


Astro School
Specialization school
Huston

The white beach school
High School
Honolulu

Queen High School
High School
London

Name	Grade	City
Astro School	Specialization school	Huston
The white beach school	High School	Honolulu
Queen High School	High School	London