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:
```
<SchemaName>.<ObjectName>
```
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.
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.