Author Archives: user

SQL – DROP or DELETE View Table of content SQL allows you to drop an exiting view and delete records from a view in a database. SQL uses DROP statement to delete all the records from the view along with its definition and using the DELETE statement, only the records are deleted while the view […]

SQL – Rename View Table of content There are various SQL statements that perform different operations on database objects, such as creating, updating, deleting and also renaming a database object. And since a view is also a database object, all these operations can also be performed on a view, you can create a view, update […]

SQL – UPDATE View Table of content SQL UPDATE View Statement A view is a database object that can contain rows (all or selected) from an existing table. It can be created from one or many tables which depends on the provided SQL query to create a view. Unlike CREATE VIEW and DROP VIEW there […]