sql - There is already an object named xyz in the database -

i created view , saved it. no problem. now, i'm trying make small change view , sql server complaining 'there object named qry_faculty in database'. yes. there is. i'm trying change , save it.

is there kind of setting can uncheck rid of this?

ensure use alter view command , not create view command since view exists. if using query designer view highly suggest don't. find view in object explorer, right click, script, alter.