Once again, select table NewUsers and click the View Dependencies command:
Check if dependencies are changed for the renamed table NewUsers. In the table list it will be renamed as NewUsers:Īfter the new name for the table is entered, and database is refreshed, the list of referenced objects will change. To see that in example, select the table Users in the Object Explorer window and from the context menu click the Rename command:Įnter new name for the table Users, for example NewUsers and refresh database NewDB.
#Sql server rename column code#
To use these database objects after the table Users is renamed, their code must be modified manually. After renaming the table Users, there won’t be any dependency related errors.īut, the name modification of the table Users, will make non-schema bound dependencies objects invalid. Some of the referenced objects have schema-bound dependencies to the table Users (trigger trgAfterInsert and table Address), and some of them have non-schema-bound dependencies (stored procedures sp_GetUserCity and sp_GetUserAddress, and view v_Address01).ĭatabase objects that have schema-bound dependencies to the table Users will automatically accept all changes made. In the list in the Object Dependencies window are all objects from the database NewDB, that depend on the table Users: This command will open the Object Dependencies window for selected table, in this case for the table Users.
To see dependencies for the table Users, select it in the Object Explorer and choose from the context menu View Dependencies command. įOR INSERT AS PRINT 'Data entered successfully' GO
0 kommentar(er)
