:::: MENU ::::

The CREATE SCHEMA statement should be followed by a name or authorization keyword.

  • Jun 30 / 2009
  • 0
dbDigger, Security and Permissions

The CREATE SCHEMA statement should be followed by a name or authorization keyword.

The Error Message:
Msg 4111, Level 15, State 1, Line 1
The CREATE SCHEMA statement should be followed by a name or authorization keyword.

is a run time error message introduced in SQL Server 2005. This error message appears when you try to create a new schema with CREATE SCHEMA without specifying anything else.
While creating a new schema you must specify either a schema name or an authorization keyword right after the CREATE SCHEMA command.

Example of such error generated is as follows

USE tempdb;
GO
CREATE SCHEMA
Consult us to explore the Databases. Contact us