clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36319 in the last week).

CREATE TABLE Schools( [Name] varchar(250), [Grade] varchar(150), [City] varchar(150));
 hidden batch(es)


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
 hidden batch(es)


SELECT * FROM Schools
Name Grade City
Astro School Specialization school Huston
The white beach school High School Honolulu
Queen High School High School London
 hidden batch(es)


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


SELECT * FROM Schools
Sign Grade City
Astro School Specialization school Huston
The white beach school High School Honolulu
Queen High School High School London
 hidden batch(es)