Facebook
Welcome to Techsapphire

complex query

SQL VIEWS and Security

What View do ?• First,  It help you break down complex queries.• Secong, Query reusability.• Third, Security.(not fully recommendable) What is View ?View is just a stored query. Can also be said as virtual table. They don’t hold any data into them.Data comes from real tables.SQL select query operator (WHERE, ORDER BY, etc) can be used with it. […]