Double-dot notation
When operating in NPS compatibility mode, you can use double-dot notation to specify a database object.
Double-dot notation follows this
format:
<NPS_DatabaseName>..<NPS_ObjectName>
The two dots indicate
that the schema name is not specified. How such a statement is interpreted depends on the setting of
the SQL_COMPAT global variable:- When SQL_COMPAT='NPS', the statement is interpreted
as:
Provided that you moved your NPS database to a schema that has the same name as the database, you can use existing SQL scripts that were written for the NPS database without having to adjust their syntax.<SchemaName>.<ObjectName>
- Otherwise, because two dots refer to a method invocation of an abstract data type, a statement with two dots would result in a syntax error.