Error Message:
Msg 4111, Level 15, State 1, Line 1
The CREATE SCHEMA statement should be followed by a name or authorization keyword.
Severity level:
15.
Description:
This error message appears when you try to create a new schema with CREATE SCHEMA without specifying anything else.
Consequences:
The T-SQL statement can be parsed, but causes the error at runtime.
Resolution:
Errors of the Severity Level 15 are generated by the user and can be fixed by the SQL Server user. The statement cannot be executed this way. You must specify either a schema name or an authorization keyword right after the CREATE SCHEMA command.
Versions:
This error message was introduced with SQL Server 2005.
Example(s):
USE tempdb;
GO
CREATE SCHEMA
Remarks:
In the above example we try to create a new schema via CREATE SCHEMA without specifying anything else. This raises the error.