To avoid all of these hard work, you can rename the table and create a synonym for it to keep existing applications function properly. In addition, all current applications that use this table need to be changed and possibly to be recompiled. When you want to rename a table or any other object such as a view, stored procedure, user-defined function, or a sequence, the existing database objects that reference to this table need to be manually modified to reflect the new name. If you refer to an object from another database (even from a remote server), you can create a synonym in your database and reference to this object as it is in your database. You will find some situations which you can effectively use synonyms. Code language: SQL (Structured Query Language) ( sql ) When to use synonyms
0 kommentar(er)
