About database view

Hi,

Anyone who knows the definition of database view?

and what is database view used for?

I'll appreciate it if someone answer my question.

thanks a lot.

Slight smile

  Discussion posts and replies are publicly visible

Parents
  • The view is virtual table created from the base table and they don't have physical existence in the database. it contains rows and columns like a real table.

    views are used for security purpose, for ex. u have a data of US employee like emp_id, emp_name, emp_department and their emp_SSNNo.....now u dont want to show the SSN number to the user u can hide it using views means u are keeping it secure and hiding confidential info.

Reply
  • The view is virtual table created from the base table and they don't have physical existence in the database. it contains rows and columns like a real table.

    views are used for security purpose, for ex. u have a data of US employee like emp_id, emp_name, emp_department and their emp_SSNNo.....now u dont want to show the SSN number to the user u can hide it using views means u are keeping it secure and hiding confidential info.

Children
No Data