Use the CREATE NICKNAME statement to register a nickname for a Microsoft SQL
Server table or view that you want to access. This topic provides a complete
example with the required parameters.
The following example shows how to register a nickname for a Micrsoft
SQL Server table or view using the CREATE NICKNAME statement.
CREATE NICKNAME cust_africa FOR sqlserver."vinnie"."egypt"
- cust_africa
- A unique nickname that is used to identify the Microsoft SQL Server table or view.
Important: The nickname is a two-part name—the schema and the nickname.
If you omit the schema when you register the nickname, the schema of the nickname
will be the authorization ID of the user who registers the nickname.
- sqlserver."vinnie"."egypt"
- A three-part identifier for the remote object:
- sqlserver is the server definition name that you assigned
to the Microsoft SQL Server remote server in the CREATE
SERVER statement.
- vinnie is the user ID of the owner to which the table
or view belongs.
- egypt is the name of the remote table or view that
you want to access.
The federated server folds the names of the Microsoft SQL
Server schemas and tables to uppercase unless you enclose the names in quotation
marks.