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 |