![]() EXEC sp_rename '', 'ErrorDateTime', 'COLUMN' The following example renames the column ErrorTime in the table dbo.ErrorLog to ErrorDateTime in the AdventureWorksLT database. Select the column whose name you want to change and type a new value for Name. You can also change the name of a column in the Column Properties tab. On the File menu, select Save table name.Under Column Name, select the name you want to change and type a new one.In Object Explorer, right-click the table to which you want to rename columns and choose Design.In Object Explorer, right-click the table in which you want to rename columns and choose Rename. ![]()
2 Comments
1/31/2023 11:24:46 pm
Thanks for sharing this informative blog
Reply
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |