T-SQL Tutorial

Msg 4511 Level 16 - Create View or Function failed because no column name was specified


Transact sql error message Msg 4511 Level 16 - Create View or Function failed because no column name was specified - means that in your view exist an concatenated column composed of multiple columns and has not declared an alias.

Msg 4511 Level 16 Example:

Invalid create view:

USE model;
GO
CREATE VIEW studentsList AS
SELECT id, CONCAT(first_name,' ',last_name), gender
FROM students
GO

Message
Msg 4511, Level 16, State 1, Procedure studentsList, Line 2
Create View or Function failed because no column name was specified for column 2.




Correct create view:

USE model;
GO
CREATE VIEW studentsList AS
SELECT id, CONCAT(first_name,' ',last_name) full_name, gender
FROM students
GO

Message
Command(s) completed successfully.

Other error messages: