ALTER TYPE(7) SQL Commands ALTER TYPE(7)NAME
ALTER TYPE - change the definition of a type
SYNOPSIS
ALTER TYPE name RENAME TO new_name
ALTER TYPE name OWNER TO new_owner
ALTER TYPE name SET SCHEMA new_schema
DESCRIPTION
ALTER TYPE changes the definition of an existing type.
You must own the type to use ALTER TYPE. To change the schema of a type, you must also have CREATE privilege on the new schema. To alter
the owner, you must also be a direct or indirect member of the new owning role, and that role must have CREATE privilege on the type's
schema. (These restrictions enforce that altering the owner doesn't do anything you couldn't do by dropping and recreating the type. How-
ever, a superuser can alter ownership of any type anyway.)
PARAMETERS
name The name (possibly schema-qualified) of an existing type to alter.
new_name
The new name for the type.
new_owner
The user name of the new owner of the type.
new_schema
The new schema for the type.
EXAMPLES
To rename a data type:
ALTER TYPE electronic_mail RENAME TO email;
To change the owner of the type email to joe:
ALTER TYPE email OWNER TO joe;
To change the schema of the type email to customers:
ALTER TYPE email SET SCHEMA customers;
COMPATIBILITY
There is no ALTER TYPE statement in the SQL standard.
SQL - Language Statements 2010-05-14 ALTER TYPE(7)
Check Out this Related Man Page
ALTER AGGREGATE(7) SQL Commands ALTER AGGREGATE(7)NAME
ALTER AGGREGATE - change the definition of an aggregate function
SYNOPSIS
ALTER AGGREGATE name ( type [ , ... ] ) RENAME TO new_name
ALTER AGGREGATE name ( type [ , ... ] ) OWNER TO new_owner
ALTER AGGREGATE name ( type [ , ... ] ) SET SCHEMA new_schema
DESCRIPTION
ALTER AGGREGATE changes the definition of an aggregate function.
You must own the aggregate function to use ALTER AGGREGATE. To change the schema of an aggregate function, you must also have CREATE priv-
ilege on the new schema. To alter the owner, you must also be a direct or indirect member of the new owning role, and that role must have
CREATE privilege on the aggregate function's schema. (These restrictions enforce that altering the owner doesn't do anything you couldn't
do by dropping and recreating the aggregate function. However, a superuser can alter ownership of any aggregate function anyway.)
PARAMETERS
name The name (optionally schema-qualified) of an existing aggregate function.
type An input data type on which the aggregate function operates. To reference a zero-argument aggregate function, write * in place of
the list of input data types.
new_name
The new name of the aggregate function.
new_owner
The new owner of the aggregate function.
new_schema
The new schema for the aggregate function.
EXAMPLES
To rename the aggregate function myavg for type integer to my_average:
ALTER AGGREGATE myavg(integer) RENAME TO my_average;
To change the owner of the aggregate function myavg for type integer to joe:
ALTER AGGREGATE myavg(integer) OWNER TO joe;
To move the aggregate function myavg for type integer into schema myschema:
ALTER AGGREGATE myavg(integer) SET SCHEMA myschema;
COMPATIBILITY
There is no ALTER AGGREGATE statement in the SQL standard.
SEE ALSO
CREATE AGGREGATE [create_aggregate(7)], DROP AGGREGATE [drop_aggregate(7)]
SQL - Language Statements 2010-05-14 ALTER AGGREGATE(7)
I'm writting a shell script to email customers invoices.
after each RCPT to: email@address.com, i've put in a sleep 1 command,
but with 2000 customers to email and about 5 or 6 of these sleep commands it can take a very long time.
Is there any smaller amount of time the sleeper can sleep for... (4 Replies)
I have a KSH script that runs a SQL script, then sends an email to me indicating that it's completed. I would like to modify it so that the body of the email will contain a count of the number of records Added, Changed, Deleted as a result of the SQL script.
Here's what I was trying, but it's... (2 Replies)
Guys,Please look at a simple shell which validates presence of a customer table in OASIS schema. SQL Query for validation is wrong(Table name in quotes should not have schema name OASIS.). And shell is working correctly (with exit 1) as it will never get count=1 with this query.
But it is... (2 Replies)
Made a sysback tape backup on our 595 running 4.1.5 but when trying to do a restore discovered that rmt0 not in bootlist(s).
Tried to alter both the normal and service bootlists but system wont respond to F7(commit).
Erased the service boolist then tried alter again, same result. Now have... (2 Replies)
I have a list of names and email addresses, like this. The <tab> markers are actually tabs.
joe.blow <tab> joe.blow@wherever.com
tom.t.hall <tab> tom.t.hall@wherever.com
john.r.smith <tab> john.r.smith@wherever.com
sally.jones <tab> sally.jones@state.or.us
I want to parse the data so that... (3 Replies)
I am profoundly new to *nix, but had a project dropped in my lap that has sparked an interest, leading me here.
I was tasked with daily sending one of our customers a listing of all the spam our filter blocked that was heading for them.
Between Google and I;
I discovered the Server is running... (3 Replies)
How can
grep G.*schema
give me the result: ${Gacntg_dt}""'"'
doesn't G.*schema say give me an unlimited number of characters between G and schema?
:confused: (3 Replies)
I want to send email for every row comes out of following SQL statement
thank you for your help.
*****SQL STATEMENT******
Select SCUSER AS "USER IDS" , SCEUSER AS "LOCKED OUT" FROM SYS.7333.F98OWSEC;
*******OUPUT COMES LIKE THIS AND ONE EMAIL COMES AS PER SCRIPT BELOW******
******BUT... (4 Replies)
I have SQL giving me output of disabled ids in the system every day.
I can send on email for this disabled user list.
But I want to send one email for every disabled user or for every row.
thank you for your help.
Kyle (2 Replies)
Write a sh or bash script to manage the customers' information. The script should allow the user to add and remove a customer, display all customers (sorted by LastName, FirstName, PhoneNumber, Company, or Email), and search a customer's information by his/her name. The script should be menu-based... (1 Reply)
Hi
I want to change the color of the email content sent through unix. I tried a lot and left in vain. I heard that it could be done by sending the email as HTML. But I don't how to do it. Can you all share your ideas?
~sakthifire (1 Reply)
Any ideas on who could possibly be good providers enough to give me an easy installation of email server for my house without any technical issues? (1 Reply)
I have 3 files, data file,schema file and a threshold file.
Data file contains data in which columns are distributed according to schema file. This data file doesn't contain any headers.
Three continuous columns in the data file represent single variable in schema file.
first column represent... (1 Reply)
Neo
Thanks for your reply to my original post, entitled "Problem changing the email address associated with my unix.com account".
I am unable to reply to you in that thread, as I am unable to log-on to unix.com!
From what you said about purging dormant accounts, it is likely that my account... (1 Reply)