Database Objects in SQL Server – SQL Server Tutorial

 DATABASE OBJECTS :-

 The different database objects are:

  • Tables
  • Views
  • Synonyms
  • Indexes
  • Indexed views
  • procedures
  • Functions
  • DB triggers

VIEWS   :-

  •  A view is a “ subset of a table” and also called “virtual table” (or) “stored query”.
  • Views  are mainly created for Security and Simplicity.
  • By creating views, specific columns & specific rows can be granted to users.
  • Views are two types  :-

(A)  SIMPLE VIEWS

(B)   COMPLEX VIEWS.

Leave a Reply

Your email address will not be published. Required fields are marked *