VIEWS IN SQL SERVER

  • A view can be used to reduce the complexity of database schema.
  • Views are used to implement the security mechanism in SQL Server.
  • System Defined View
CUSTOMER TABLE
PRODUCT TABLE
CREATE VIEW
RENAME VIEW
RENAME SUCCESSFULLY
INFORMATION ABOUT VIEW
ALTER VIEW
ADD A NEW COLUMN
ADDED COLUMN IN TABLE
REFRESH VIEW
SCHEMABINDING IN VIEW
WARNING
ENCRYPTION IN VIEW
DROP VIEW
SYSTEM VIEW
  • Catalog View
INFORMATION SCHEMA IN VIEW
CATALOG VIEW
  • The second query will provide the information about all the databases defined by the system, including user-defined and system-defined database.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store