SQL: View
SQL View
#rasodemekontha
https://twitter.com/hashtag/rasodemek...
Views are virtual tables that hold data from one or more tables.
A view does not contain any data itself
Views are used for security purposes in databases
Syntax:
CREATE VIEW view_name AS SQL__query;
Operations:
Retrieve Data from View
Select * from view_name;
Rename view
exec Sp_Rename view1, view2;
Getting view information
exec Sp_Helptext view_name;
Modify View definition
ALTER VIEW view_name AS
SQL__Query
Refresh view
exec sp_refreshview view_name;
Drop view
DROP VIEW view_name;
Happy Learning!!
Connect me on Instagram for any queries -
/ thisisanandyadav