can we delete the trigger in a view? if yes why if not why?

Answer Posted / deep

YES OFFCOURSE ... WE CAN DELETE THE TRIGGER VIEW AS USING DROP COMMAND. IN ORDER TO DROP ANY TRIGGER



DROP TRIGGER TRIGGER_NAME;

TIGGER DROPPED.....

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between delete, truncate and drop command?

542


What are sql data types?

538


Why cannot I use bind variables in ddl/scl statements in dynamic sql?

658


what is bcp? When is it used?

574


What is cursor explain with example?

546






what are all types of user defined functions? : Sql dba

540


How to Declare Fixed Length String Value In PL SQL

657


how to use in conditions? : Sql dba

506


What's the procedure?

484


What are local and global Indexes and where they are useful.

923


How to select unique records from a table?

565


What is the default isolation level in sql server? : Transact sql

560


What is query syntax?

515


What is sql lookup?

505


What are the packages in pl sql?

566