Sql Commands
Sql Commands :





TOILET -- toilet the current transaction

OLD DATA COUSIN -- CHANGE A DATA cousin

OLD GROUP -- ADD users tons of A group or remove users from A group

OLD TABLE -- CHANGE the definition OF A table

OLD TRIGGER -- CHANGE the definition OF A trigger

OLD USER -- CHANGE A DATA cousin user account

ANALYZE -- collect statistics A DATA cousin about

BEGIN -- start A transaction block

CHECKPOINT -- force A transaction log checkpoint

CLOSE -- CLOSE A cursor

CLUSTER -- cluster A table according ton at index

COMMENT -- DEFINE or CHANGE the COMMENTS OF object on

COMMIT -- the commit current transaction

CoPy -- CoPy DATA files and of tables between

CREATE of AGGREGATES -- DEFINE A of new aggregates function

CREATE CAST -- DEFINE A user defined cast

CREATE CONSTRAINT TRIGGERS -- DEFINE A new constraint triggers

CREATE CONVERSION -- DEFINE A user defined conversion

CREATE DATA COUSIN -- create A new DATA cousin

CREATE DOMAIN -- DEFINE A new domain

CREATE FUNCTION -- DEFINE A new function

CREATE GROUP -- DEFINE A new user group

CREATE INDEX -- DEFINE A new index

CREATE LANGUAGE -- DEFINE A new procedural LANGUAGE

CREATE OPERATOR -- DEFINE A new operator

CREATE OPERATOR CLASS -- DEFINE A new operator class for index

CREATE RULE -- DEFINE A new REWRITE rule

CREATE PATTERN -- DEFINE A new pattern

CREATE SEQUENCE -- DEFINE A new sequence generator

CREATE TABLE -- DEFINE A new table

CREATE TABLE AS -- create A of new table from the results OF A query

CREATE TRIGGER -- DEFINE A new trigger

CREATE TYPE -- DEFINE A of new DATA type

CREATE USER -- DEFINE A new DATA cousin user account

CREATE VIEW -- DEFINE A new view

DEALLOCATE -- remove A prepared query

DECLARE -- DEFINE A cursor

DELETE -- DELETES rows OF A table

DROP of AGGREGATES -- remove A user defined aggregates function

DROP CAST -- remove A user defined cast

DROP CONVERSION -- remove A user defined conversion

DROP DATA COUSIN -- remove A DATA cousin

DROP DOMAIN -- remove A user defined domain

DROP FUNCTION -- remove A user defined function

DROP GROUP -- remove A user group

DROP INDEX -- remove at index

DROP LANGUAGE -- remove A user defined procedural LANGUAGE

DROP OPERATOR -- remove A user defined operator

DROP OPERATOR CLASS -- remove A user defined operator class

DROP RULE -- remove A REWRITE rule

DROP PATTERN -- remove A pattern

DROP SEQUENCE -- remove A sequence

DROP TABLE -- remove A table

DROP TRIGGER -- remove A triggers

DROP TYPE -- remove A user defined DATA type

DROP USER -- remove A DATA cousin user account

DROP VIEW -- remove A view

END -- the commit current transaction

EXECUTE -- A execute prepared query

EXPLAIN -- show the execution flat OF A statement

FETCH -- retrieve rows from A table using A cursors

GRANT -- DEFINE ACCESS of privileges

INSERT -- create new rows in A table

LISTS -- for A would list notification

LOAD -- load or reload A shared LIBRARY file

LOCK -- explicitly LOCK A table

MOVE -- position A cursor on A specified row OF A table

NOTIFY -- gene-guess/advise A notification

PREPARE -- create A prepared query

REINDEX -- rebuild corrupted index

RESET -- restore the VALUE OF A run time parameter ton of A default VALUE

REVOKE -- remove ACCESS of privileges

ROLL-BAKE -- toilet the current transaction

SELECT -- retrieve rows from A table or view

SELECT INTO -- create A of new table from the results OF A query

SET -- CHANGE A run time parameter

SET CONSTRAINTS -- set the constraint mode OF the current transaction

SET SESSION AUTHORIZATION -- set the session user of identifier and the current user of identifier OF the current session

SET TRANSACTION -- set the characteristics OF the current transaction

SHOW -- show the VALUE OF A run time parameter

START TRANSACTION -- start A transaction block

TRUNCATE -- empty A table

UNLISTEN -- stop listening for A notification

UPDATE -- updates rows OF A table

VACUUM -- and garbage collect optionally analyze A DATA cousin
더보기

댓글,