SQLRef / Quick Reference / Commands / ALL
SQLRef Menu:
  • Quick Reference:
  • My Bookmarks
Enter a specific command or browse:

| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | All |
Index for "All":
rollback abort a transaction
commit commit a transaction
create rule define a new rule
create sequence create a new sequence number generator
create table create a new table
create trigger create a new trigger
create type create a new user-defined base data type
create user create a new user
create view create a view
declare set up a cursor
delete delete tuples
drop Please be more specific:
drop aggregate remove an aggregate function
drop database remove a database
drop function remove a user-defined function
drop index remove an existing index
drop operator remove a user-defined operator
drop rule remove a rule
drop sequence remove a sequence number generator
drop table remove a table
drop trigger remove a trigger
drop type remove a user-defined base type
drop user remove a user from the system
drop view remove a view
end work end the current transaction
explain explain the query execution plan
fetch retrieve tuples from a cursor
grant grant access control to a user or group
insert insert tuples
listen listen for notification on a condition name
load dynamically load a module
lock exclusive lock a table inside a transaction
move move an cursor position
notify signal all frontends listening on a condition name
reset set run-time environment back to default
revoke revoke access control from a user or group
select retrieve tuples
set set run-time environment
show show current run-time environment
unlisten stop listening for notification on a condition name
update update tuples
vacuum vacuum the database, i.e. cleans out deleted records, updates statistics
abort abort the current transaction
alter table add/rename attributes, rename tables
alter user alter system information for a user
begin work begin a new transaction
cluster create a clustered index (from an existing index)
close close an existing cursor (cursor)
copy copy data to and from a table
create Please be more specific:
create aggregate define an aggregate function
create database create a database
create function create a user-defined function
create index construct an index
create operator create a user-defined operator
SQLRef Designed by Quentin Smith, © 2001-2003
Email the webmaster.
348069 hits since January, 2001.

Creative Commons License
This work is licensed under a Creative Commons License.