DROP TRIGGER(7) SQL Commands DROP TRIGGER(7)NAME
DROP TRIGGER - remove a trigger
SYNOPSIS
DROP TRIGGER name ON table [ CASCADE | RESTRICT ]
INPUTS
name The name of an existing trigger.
table The name (optionally schema-qualified) of a table.
CASCADE
Automatically drop objects that depend on the trigger.
RESTRICT
Refuse to drop the trigger if there are any dependent objects. This is the default.
OUTPUTS
DROP TRIGGER
The message returned if the trigger is successfully dropped.
ERROR: DropTrigger: there is no trigger name on relation "table"
This message occurs if the trigger specified does not exist.
DESCRIPTION
DROP TRIGGER will remove an existing trigger definition. To execute this command the current user must be the owner of the table for which
the trigger is defined.
EXAMPLES
Destroy the if_dist_exists trigger on table films:
DROP TRIGGER if_dist_exists ON films;
COMPATIBILITY
SQL92 There is no DROP TRIGGER statement in SQL92.
SQL99 The DROP TRIGGER statement in PostgreSQL is incompatible with SQL99. In SQL99, trigger names are not local to tables, so the command
is simply DROP TRIGGER name.
SEE ALSO
CREATE TRIGGER [create_trigger(7)]
SQL - Language Statements 2002-11-22 DROP TRIGGER(7)
Check Out this Related Man Page
ALTER TRIGGER(7) PostgreSQL 9.2.7 Documentation ALTER TRIGGER(7)NAME
ALTER_TRIGGER - change the definition of a trigger
SYNOPSIS
ALTER TRIGGER name ON table_name RENAME TO new_name
DESCRIPTION
ALTER TRIGGER changes properties of an existing trigger. The RENAME clause changes the name of the given trigger without otherwise changing
the trigger definition.
You must own the table on which the trigger acts to be allowed to change its properties.
PARAMETERS
name
The name of an existing trigger to alter.
table_name
The name of the table on which this trigger acts.
new_name
The new name for the trigger.
NOTES
The ability to temporarily enable or disable a trigger is provided by ALTER TABLE (ALTER_TABLE(7)), not by ALTER TRIGGER, because ALTER
TRIGGER has no convenient way to express the option of enabling or disabling all of a table's triggers at once.
EXAMPLES
To rename an existing trigger:
ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs;
COMPATIBILITY
ALTER TRIGGER is a PostgreSQL extension of the SQL standard.
SEE ALSO
ALTER TABLE (ALTER_TABLE(7))
PostgreSQL 9.2.7 2014-02-17 ALTER TRIGGER(7)
This is my first posting. I am not a very sophisticated UNIX user.
I am trying to have an existing control string trigger another process at 4:00 p.m. My command looks like this on System V.4 UNIX.
at -f /scriptname 16:00
I have added the users to /etc/cron.d/at.allow and at.deny is... (5 Replies)
I created a file contains:
create table .....;
create index ....;
create trigger...;
and I want to substitue from my file ; by ;-- from the line where appears create trigger to the end of the file and keep intact the create table step and index in the file.
awk '/CREATE... (2 Replies)
I need a script that will always return an engine of table, which not
depends on the table structure.
I need it to be done exactly from the "show create table ..." statement.
If there is a easiest way, except "show table status", please write.
mysql -u root db -sBe "show create table... (1 Reply)
Hi GUYS,
I need to trigger 3 stored procedure at the same time..
I know how to trigger the stored procedure. If anybody can tell me how to trigger 3 different process at the same time parallelly.. that would be helpful..
Thanks for your help in advance,
Magesh (1 Reply)
Hi All,
I remove the default gateway by using a command line but I need also to remove it from ODM so that reboot will not trigger it back.
How do I remove it from ODM of AIX 5.3?
Thanks for any comment you may add. (4 Replies)
Hi, this is my first shell script. Anyway i am trying to ftp files from one machine to another. The name of the script is ifsftp_orabkp. The code is as follows:
HOST="122.122.122.22"
USER="ftp_ftp"
PASSWD="ftp.222222"
Y1=`(perl -e '@y=localtime(time());printf... (11 Replies)
Hello Team,
I have a script in which more than 500 trigger statemetns are written.
i need to filter all lines from that script file which containts "CREATE TRIGGER" word in each line
is it possible using linux commands??
example:
CREATE TRIGGER S1.T1
.................. (10 Replies)
Hi..Is it possible for unix to monitor outlook for a particualr period of time and trigger oracle upon receiving a mail with particular content...
Thanks in advance (1 Reply)
what I'm trying to do is ... need to drop tables w/ names like
ABC_NY_2001
ABC_ORD_2001
ABC_TX_2001
ABC_CL_2001
For this, I want to write a query "DROP TABLE ABC_var_2001".
now "var" should be either NY, ORD, TX or CL.
I'm new to programming so don't know how to create a variable w/ OR... (3 Replies)
Hello,
I'm working with putty on Windows 7 professional and I'd like to know if there's a way to gather specific lines from a pre-existing table and make a new table with that information.
More specifically, I'd like the program to look at a specific column, say column N, and see if any of the... (5 Replies)
Hi,
I need to create a trigger file named "start" at 4 pm daily . Once this file is created , another process would be initiated. How do i do it using touch command in unix ?
My script that should have touch command shall be present in a dir /app/user/script while the trigger file should be... (2 Replies)
Right I have a MYSQL database with table1 with 3 columns, colA, colB and colC. I want to combine the data in the 3 columns into a 4th column names col_comb. Here's the SQL command that works:
UPDATE table1 SET `col_comb` = CONCAT( `colA` , ' - ', `colB` , ', ', `colC` );
So now I want this... (5 Replies)
Hi Experts,
We are developing a script which will wait for the trigger file(with datetime in the trigger file name).
But the problem is when I use 'while' loop to wait for the file, it waits for the filename with wilcard in it that is wait for 'Trigger*.done' file. :eek:
Below is the script
... (4 Replies)
I have a script that will be placing a trigger file for other applications.
The user-inputted path is similar to:
"/data/region/NorthAm/Project HAV 8H"
The project path will not change throughout the script. However, pwd changes as the scanning continues in the script. I need to truncate... (3 Replies)
Hello Everyone,
I have written a file validation script in unix to compare the data and trigger file.My requirement is if the file validation fails,I need to upate the error details in a table
ex:Below is the one of many validation checks i am doing
if
then
echo "Actual count between... (3 Replies)