Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Rename column name using 'sp_rename' command
CREATE TABLE Sales (EmpId INT, Yr INT, price MONEY) INSERT Sales VALUES(1, 2005, 12000) INSERT Sales VALUES(1, 2006, 18000) INSERT Sales VALUES(1, 2007, 25000) INSERT Sales VALUES(2, 2005, 15000) INSERT Sales VALUES(2, 2006, 6000) INSERT Sales VALUES(3, 2006, 20000) INSERT Sales VALUES(3, 2007, 24000) execute sp_rename 'Sales.Yr','Year','COLUMN' select * from Sales
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
MyDatabase
aa
Resolved error
EmployeeDetails
Gatoactual
testing-2
EXP 8 q2
tp3
Task_5_Final
Merge Sample Code
Please log in to post a comment.