トーク:SQL

ページのコンテンツが他言語でサポートされていません。
出典: フリー教科書『ウィキブックス(Wikibooks)』

未執筆[編集]

  • CREATE ASSERTION
  • CREATE CARACTER SET
  • CREATE COLLATION
  • CREATE DOMAIN
  • CREATE SCHMA
  • CREATE TRANSLATION
  • CREATE VIEW
  • CHECK
  • GRANT
  • DECLARE TIME DISPLACEMENT TABLE
  • DROP SCHEMA
  • DROP DOMAIN
  • DROP TABLE
  • DROP VIEW
  • DROP ASSERTION
  • REVOKE
  • DROP COLLATION
  • DROP CHARACTER SET
  • DROP TRANSLATION
  • ALTER DOMAIN
  • ALTER TABLE ADD / ALTER TABLE DROP
  • ADD DEFAULT
  • REPLACE DEFAULT
  • DROP DEFAULT
  • ADD CHECK
  • DROP CONSTRAINT
  • DECLARE CURSOR
  • OPEN
  • FETCH
  • CLOSE
  • SELECT
  • DELETE(CURSOR)
  • UPDATE(CURSOR)
  • DELETE(WHERE)
  • UPDATE(WHERE)
  • DECLARE LOCAL TEMPORARY TABLE

Dynamic SQL[編集]

  • USING
  • ALLOCATE DESCRIPTION
  • DEALLOCATE DESCRIPTION
  • GET DESCRIPTION
  • SET DESCRIPTION
  • PREPARE
  • DEALLOCATE PREPARE
  • DESCRIBE
  • EXECUTE
  • EXECUTE IMMEDIATE
  • DECLARE CURSOR(Dynamic)
  • ALLOCATE CURSOR
  • OPEN(Dynamic)
  • FETCH(Dynamic)
  • CLOSE(Dynamic)
  • DELETE(Dynamic, CURSOR)
  • DELETE(Dynamic, WHERE)

TRANSACTION[編集]

  • CONNECT
  • SETCONNECTION
  • DISCONNECT

単語のみ[編集]

  • COMMIT
  • ROLLBACK
  • SET TRANSACTION

概要のみ(例題、図解無し)[編集]

  • PRIMARY KEY
  • FOREIGN KEY
  • UNIQUE
  • NOT NULL

たぶん書き終わり[編集]

  • CREATE TABLE
  • INSERT