Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

alter_trigger(7) [debian man page]

ALTER 
TRIGGER(7) SQL Commands ALTER TRIGGER(7) NAME
ALTER TRIGGER - change the definition of a trigger SYNOPSIS
ALTER TRIGGER name ON table RENAME TO newname 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 The name of the table on which this trigger acts. newname 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)] SQL - Language Statements 2010-05-14 ALTER TRIGGER(7)

Check Out this Related Man Page

ALTER 
TRIGGER(7) SQL Commands ALTER TRIGGER(7) NAME
ALTER TRIGGER - change the definition of a trigger SYNOPSIS
ALTER TRIGGER name ON table RENAME TO newname 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 The name of the table on which this trigger acts. newname 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)] SQL - Language Statements 2010-05-14 ALTER TRIGGER(7)
Man Page

15 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

failure of at command

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)
Discussion started by: DKuester
5 Replies

2. UNIX for Dummies Questions & Answers

Newb question

I don't even know if this should go here but I just would like to know what this means: d0e45878043844ffc41aac437e86b602 I know absolutely nothin' about UNIX, and I found this in a SQL table in a board I run. Someone please tell me what that is in "normal" mode. Pardon me for my... (4 Replies)
Discussion started by: daeglin
4 Replies

3. Shell Programming and Scripting

SQL Commands in Unix

Hi gurus, Being a newbie not sure whether iam asking the right question? can we use oracle commands in unix for ex: to read a count on a table. if so, what needs to be configured and etc.. any kind of help is appreciated. Thanks sish (6 Replies)
Discussion started by: sish78
6 Replies

4. Shell Programming and Scripting

Search a line and output next line as well

Hi, I have a requirement to search a particular text and if found print next line also. Appreciate your help. Thanks (10 Replies)
Discussion started by: kamranjalal
10 Replies

5. Shell Programming and Scripting

store the table data in excel file

Hello - I have a below table and i want to extract the data into excel sheet and send to different location. Here is the table structure... SQL> desc t_i1_exportdocs Name Null? Type ----------------------------------------- --------... (11 Replies)
Discussion started by: govindts
11 Replies

6. Shell Programming and Scripting

How to grep the where clause of a SQL?

Hi UNIX Gurus, I want to use extract the where clause of a SQL present in a file. Please suggest me how can I do it. Select * from emp where emp_id>10; cat <file_name> | grep -i "where" returns whole SQL. how can I extract only "where emp_id>10;" Thanks in advance (4 Replies)
Discussion started by: ustechie
4 Replies

7. UNIX for Dummies Questions & Answers

How to copy one columns and print to the last column in unix?

I want to copy column no 3 to the end of column example : alter table RECOVER_USR.MPULKIXD rename to alter table RECOVER_USR.CS_ADV_PROMO rename to alter table RECOVER_USR.BCH_HISTORY_TABLE rename to alter table BILLOPS.HISHAM_DATAPLUS_FINAL rename to alter table... (8 Replies)
Discussion started by: arifahel
8 Replies

8. Shell Programming and Scripting

How to filter a whole line using a word?

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)
Discussion started by: kanakaraju
10 Replies

9. UNIX for Dummies Questions & Answers

Creating a condensed table from a pre-existing table in putty

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)
Discussion started by: Deedee393
5 Replies

10. Shell Programming and Scripting

Cut Lines using grep

Hi, I have a SQL script with "create table" and "alter table" statements and I want to cut all the alter table statements from original file (A) and move it to a different file (B). Can you please me the option. Thanks a lot for your time. (3 Replies)
Discussion started by: bhupinder08
3 Replies

11. Shell Programming and Scripting

How to grep the desired output and output to a file?

currently I have process from a raw file to this stage ALTER TABLE "EXCEL_ADMIN"."TC_TXN_VOID" ADD CONSTRAINT "PK_TC_TXN_VOID" PRIMARY KEY ("TC_TXN_IID") ALTER TABLE "EXCEL_ADMIN"."TC_TXN_AMT" ADD CONSTRAINT "PK_TC_TXN_AMT" PRIMARY KEY ("TC_TXN_AMT_IID") ALTER TABLE... (10 Replies)
Discussion started by: jediwannabe
10 Replies

12. Shell Programming and Scripting

Execute command with loop

I have a below command ALTER TABLE `abc` ADD PARTITION ( PARTITION 20130613 VALUES less than (DAY('13'))); Below is requirement It runs in Loop as DAY start with 13 and end with 100 along with this of counter "20130613" also increases per command as the next command should be ... (8 Replies)
Discussion started by: kaushik02018
8 Replies

13. Programming

MYSQL - trigger update on record insert or update

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)
Discussion started by: barrydocks
5 Replies

14. Emergency UNIX and Linux Support

Waiting for wildcard filename to exists in while loop

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)
Discussion started by: Amey Joshi
4 Replies

15. Shell Programming and Scripting

Run a job between times else run later

Hi guys, I have written a script that waits for a trigger file. Then checks the time of the trigger. if the trigger finished between 8pm and midnight then runs a job. else it waits till 1am then runs a different job. I am still very new to scripting so any suggestions to improve my... (4 Replies)
Discussion started by: twinion
4 Replies

Featured Tech Videos