|
|
 #SQL#Syntax#Syntax Summary for the SQL |
|
|
|
※ ANSI 기준:DB2,INFROMIX,INGRES,ORACLE,SQL/DS,SYBASE 등 각 DBMS별로 약간의 서식 차이가 있을 수 있습니다..
ALTER DATABASE database_name
:데이터베이스를 수정(한 번도 사용해본 적 없습니다.)
ALTER TABLE table_name
(various options)
:테이블 구조를 수정
e.g. alert table authors add birth_date datetime null
BEGIN TRANsaction [transaction_name]
:사용자정의 트랜젝션의 시작.
COMMIT TRANsaction
:사용자정의 트랜젝션의 끝
CREATE DATABASE database_name
:데이터베이스 생성
CREATE [UNIQUE] [CLUSTERED |
NONCLUSTERED] INDEX index_name
ON table_name
(column_name [, column_name]...)
:인덱스 생성
CREATE TABLE table_name
(column_name datatype [NOT NULL | NULL]
[, column_name datatype [NOT NULL | NULL]]...)
:테이블 생성
CREATE VIEW [owner.]view_name
[(column_name [, column_name]...)]
AS select_statement
[WITH CHECK OPTION]
:뷰테이블 생성
DELETE FROM
{table_name | view_name}
[WHERE search_conditions]
:데이터 삭제
DROP DATABASE database_name
:데이터베이스 삭제
DROP INDEX
table_name.index_name [, table_name.index_name]...
:인덱스 삭제
DROP TABLE table_name
:테이블 삭제
DROP VIEW [owner.]view_name [, [owner.]view_name]...
:뷰테이블 삭제
DUMP DATABASE database_name
TO device_name
:데이터베이스 자료 비우기
DUMP TRANsaction database_name
TO device_name
:트렌젝션 자료 비우기
GRANT {ALL | privilege_list}
ON {table_name [(column_list)} |
view_name [(column_list)]
TO {PUBLIC | name_list}
GRANT {ALL | command_list}
TO {PUBLIC | name_list}
INSERT [INTO]
{table_name | view_name}
[(column_list)]
{VALUES (constant_expression
[, constant_expression]...) | select_statement}
:데이터 추가
LOAD DATABASE database_name
FROM device_name
:데이터베이스 읽어오기
LOAD TRANsaction database_name
FROM device_name
:트렌젝션 읽어오기
REVOKE {ALL | privilege_list}
ON {table_name [(column_list)] |
view_name [(column_list)]}
FROM {PUBLIC | name_list}
REVOKE {ALL | command_list}
FROM {PUBLIC | name_list}
ROLLBACK TRANsaction
[transaction_name | savepoint_name]
SAVE TRANsaction [savepoint_name]
SELECT [DISTINCT] select_list
[INTO table_name]
[FROM
{table_name | view_name},
[{table_name | view_name}]...
[WHERE search_conditions]
[GROUP BY [ALL] column_name
[, column_name]...
[HAVING search_donditions]
[ORDER BY
[{table_name. | view_name.}]
column_name |
select_list_number | expression} [ASC | DESC]
[, {[table_name. | view_name.}]
column_name |
select_list_number | expression} [ASC | DESC]]...]
:데이터 가져오기
UPDATE {table_name | view_name}
SET [{table_name. | view_name.}]
column_name1 = {expression1 | NULL | (select_statement)}
[, column_name2 = {expression2 | NULL | (select_statement)}]...
[FROM {table_name | view_name}
[, {table_name | view_name}]...
[WHERE search_conditions]
:데이터 수정
UPDATE STATISTICS
table_name [index_name]
 |
|
|
홈 
서비스 
