Database View not working in live server host

Anytime I create database view and publish to a live server, the database view aspect does not work. Any help please?

some hosts dont allow database views,especially if you are hostin on cpanel, you might need to contact them to add the view for you, better use custom views

Custom view also does not work on the live server.

you have to contact your hoster and follow up, i had a similari issue! its always the hoster’s limitations