SQL Server Synonyms - Simple Talk - Redgate Software
文章推薦指數: 80 %
SQL Server allows you to create a synonym so you can define an alternate name for an object that already exists. Synonyms function like aliases on columns or tables. However, a synonym is created as an object in a database, instead of being temporally defined at runtime.
延伸文章資訊
- 1The Ultimate Guide to SQL Server Synonym By Practical ...
In SQL Server, a synonym is an alias or alternative name for a database object such as a table, v...
- 2How to simplify SQL Server Database Object usage with ...
A Synonym can be also used to reference user-defined functions. That allows you to rename or move...
- 3同義字(Database Engine) - SQL Server | Microsoft Docs
由於沒有ALTER SYNONYM 陳述式,因此您必須先卸除同義字EmpTable,再以相同的名稱重新建立同義字,但要將同義字指向Employee 的新 ...
- 4SQL 同義字(Synonym) | 克萊兒技術部落格- 點部落
SQL 同義字(Synonym). 1284; 0 ... 因此, 認識到了SQL的同義字功能! 相當方便~ 在 ... 同義字是SQL Server 2005以上版本才提供的功能. 適用物件 ...
- 5SQL | SYNONYM - GeeksforGeeks
A SYNONYM provides another name for database object, referred to as original object, that may exi...