List few restrictions that are imposed while creating views?

devquora

devquora

Posted On: Feb 22, 2018

There are certain restrictions that are applied while creating views in database-

Only current database can have views. No other database is allowed to have views other than the current database.
You cannot make any changes in the computed values of any view.
You cannot apply full text index definitions.
Temporary views cannot be created and temporary tables cannot have views.
It is not associated with any default definitions.
There are integrity constants that define the working of commands such as insert and delete.
Triggers such as INSTEAD of is associated with views.

Related Questions

Please Login or Register to leave a response.

Never Miss an Articles from us.

Related Questions

What is DBMS?

DBMS (Database Management System) is a computer software application that allows users and other applications to view,..

Enlist various types of interactions created by DBMS ?

There are various kinds of interactions supported by DBMS like- Data definition Update Retrieval Administration..

What are the features of Database language?

Database language is used to create and store data in computer system. DBMS itself is one of the features of database l..