TSD7025: The schema type '{0}' that the .sql file contains does not match the expected schema type '{1}', based on the name of the .sql file.

  • Article

This error occurs if object type that is specified in the file name extension does not match the type of the object that is defined in the .sql file.

To correct this error

  • Rename the file in Solution Explorer so that the extension matches the contents of the file.

Example

This error appears if you have a file that is named dbo.T1.view.sql and that contains the following example Transact-SQL (T-SQL):

CREATE TABLE T1(c1 int);