TSD3023: When you create an object of this type in a database project, the object’s name must contain no more than two parts.

This error occurs when an object definition contains three or more parts where only a two-part name, of the format [Schema].[ObjectName], is expected.

To correct this error

  • Remove the additional qualifiers, and name the object by using only the [Schema].[ObjectName] syntax.

Example

This error appears if you create an object, such as a view, and give it a three-part name, as the following example shows:

CREATE VIEW DatabaseName.SchemaName.View1 
AS 
SELECT * FROM t1;

See Also

Tasks

How to: Modify Database Objects