Database Objects in SQL Server – SQL Server Tutorial


 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  :-



Leave a Reply

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