× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Like  

SQL Reference

CREATE DATABASE

CREATE DATABASE database_name [ [ WITH ]

[ OWNER [=] db_owner ]
[ TEMPLATE [=] template ] ]
 
CREATE SCHEMA
 
CREATE SCHEMA schema_name [ AUTHORIZATION username ]
[ schema_element [ ... ] ] |
[ AUTHORIZATION username [ schema_element [ ... ] ] ]

Create Table Options

CREATE [ { GLOBAL | LOCAL } { TEMPORARY | TEMP } ]
TABLE table_name
(
{column_name data_type
[ DEFAULT default_expr ]
[ IDENTITY ( seed, step) ]
[ column_constraint ]
[ ENCODE encoding ]
[ ENCRYPT encryption_type
[ DISTKEY ]
| table_constraint
| LIKE parent_table
[ { INCLUDING | EXCLUDING } DEFAULTS ] } [, ... ]
)
[ DISTSTYLE { EVEN | KEY | NONE } ]
[ SORTKEY ( column_name [, ...] ) ]
where column_constraint is:
[ CONSTRAINT constraint_name ]
{ NOT NULL |
NULL |
UNIQUE ( column_name [, ... ] ) |
PRIMARY KEY ( column_name [, ... ] ) |
FOREIGN KEY (column_name [, ... ] )
REFERENCES reftable [ ( refcolumn ) ]
[ MATCH FULL | MATCH SIMPLE ] }
and table_constraint is:
[ CONSTRAINT constraint_name ]
{ UNIQUE ( column_name [, ... ] ) |
PRIMARY KEY ( column_name [, ... ] ) |
FOREIGN KEY (column_name [, ... ] )
REFERENCES reftable [ ( refcolumn ) ]
[ MATCH FULL | MATCH SIMPLE ] }
 
CREATE VIEW
 
Creates a view in a database. The view is not physically materialized; the query that defines the view is run every time the view is referenced in a query.
 
Synopsis
CREATE [ OR REPLACE ] VIEW name [ ( column_name [, ...] ) ] AS query
 
CREATE FUNCTION

CREATE [ OR REPLACE ] FUNCTION function_name

( [ [ argname ] argtype [, ...] ] )
RETURNS return_type | TABLE
AS { 'object_file' [ , 'link_symbol' ]
| 'definition' }
LANGUAGE { C | PLPGSQL }
[ IMMUTABLE | STABLE | VOLATILE ]
[ STRICT | RETURNS NULL ON NULL INPUT | CALLED ON NULL INPUT ]
[ SECURITY INVOKER | SECURITY DEFINER ]
 
CREATE PROCEDURE
 
CREATE PROC[EDURE] procedure_name
[
@parameter data_type [, ...]
]
AS
BEGIN
sql_statement [...]
END
 
CREATE USER 
 
CREATE USER name
[ [ WITH] option [ ... ] ]
where option can be:
SYSID uid
| CREATEDB | NOCREATEDB
| CREATEUSER | NOCREATEUSER
| IN GROUP groupname [, ... ]
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
| VALID UNTIL 'abstime'
 
CREATE GROUP
 
CREATE GROUP group_name
[ [ WITH ] [ SYSID gid ] [ USER username ] [, ...] ]
 
DROP DATABASE
 
DROP DATABASE database_name
 
DROP FUNCTION
 
DROP FUNCTION name ( [ type [, ...] ] )
[ CASCADE | RESTRICT ]
 
DROP GROUP
 
DROP GROUP name
 
DROP PROCEDURE
 
DROP PROCEDURE name [, ...]
 
DROP SCHEMA
 
DROP SCHEMA name [, ...] [ CASCADE | RESTRICT ]
 
DROP TABLE
 
DROP TABLE name [, ...] [CASCADE | RESTRICT ]
 
DROP USER
 
DROP USER name [, ... ]
 
DROP VIEW
 
DROP VIEW name [, ... ] [ CASCADE | RESTRICT ]
 
 
 
 
Last updated by tariqrahiman on Dec 13, 2011 1:23 AM
This list is empty.

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017