If we drop the view any effects on actual table??

Answer 1

If you're asking about mysql/mariadb
No, it wont have any effect

Answer 2

Urvi your question is extremely vague can you help us out with your code and as to what you are speaking of in your question...
This lacks information
https://www.sololearn.com/discuss/1316935/?ref=app