What is the relation b/w view and trigger
Answer Posted / vivekanandhan
view is used to minimize the complex query of table(s), thru view we can do insert,update,delete where as trigger is an event which will execute automatically when any DML operations provided against the table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is trigger and stored procedure in sql?
Define concurrency control. : Transact sql
What does select * from mean in sql?
How do I get sql certification?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is the difference between inner join and outer join?
discuss about myisam index statistics collection. : Sql dba
what is the difference between char and varchar data types? : Sql dba
What is varchar example?
Can we create foreign key without primary key?
How to write html code in pl sql?
Why query optimization is needed?
What is the purpose of my sql?
how to install mysql? : Sql dba