Export (0) Print Expand All  Transact-SQL Syntax Conventions
(Transact-SQL)    Used for   Transact-SQL keywords.   User-
supplied parameters of Transact-SQL syntax.      | (vertical
bar)   [ ] (brackets)  Optional syntax items. Do not type the
brackets.  { } (braces)  Required syntax items. Do not type the
braces.       Transact-SQL statement terminator.Although the
semicolon is not required for most statements in this version of
SQL Server, it will be required in a future version.  <label>
::=     server_name .[database_name].[schema_name].object_name
| database_name.[schema_name].object_name  |
schema_name.object_name  | object_name   Specifies a linked
server name or remote server name.       Refers to the name of
the object.   Note Note    Object reference format   server .
database . schema . object  Four-part name.  server . database
.. object  Schema name is omitted.  server .. schema . object
Database name is omitted.  server ... object  Database and
schema name are omitted.  database . schema . obje