Export (0) Print Expand All   The database object name is
referred to as its identifier. Everything in Microsoft SQL
Server can have an identifier. Servers, databases, and database
objects, such as tables, views, columns, indexes, triggers,
procedures, constraints, and rules, can have identifiers.
Identifiers are required for most objects, but are optional for
some objects such as constraints.  An object identifier is
created when the object is defined. The identifier is then used
to reference the object. For example, the following statement
creates a table with the identifier TableX, and two columns with
the identifiers KeyCol and Description:  (KeyCol INT PRIMARY
KEY, Description nvarchar(80))  This table also has an unnamed
constraint. The PRIMARY KEY constraint has no identifier.  The
collation of an identifier depends on the level at which it is
defined. Identifiers of instance-level objects, such as logins
and database names, are assigned the default collation of the
instance. Identifiers of objects in