Data Definition Guide

From InterBase
Jump to: navigation, search

The Data Definition Guide covers information on designing and building InterBase databases. Topics include:

  • Specifying datatypes
  • Working with domains, tables, and indexes
  • Working with procedures, triggers, and generators
  • Encrypting databases and columns
  • Character sets and collation orders

Chapters

Chapter Description SQL Statements
Chapter 1: Using the Data Definition Guide The InterBase Data Definition Guide provides information on the following topics:
  • Designing and creating databases
  • Working with InterBase structures and objects, including data types, domains, tables, indexes, and views
  • Working with tools and utilities such as stored procedures, triggers, Blob filters, and generators
  • Planning and implementing database security
  • Character sets and collation orders
-
Chapter 2: Designing Databases
  • Planning and designing a database
  • Understanding data integrity rules and using them in a database
  • Planning physical storage
Chapter 3: Creating Databases Creating an InterBase database CREATE/ALTER/DROP DATABASE
Chapter 4: Specifying Data Types Choosing a data type CREATE/ALTER TABLE

CREATE/ALTER DOMAIN

Chapter 5: Working with Domains Creating, altering, and dropping domains CREATE/ALTER/DROP DOMAIN
Chapter 6: Working with Tables
  • Creating and altering database tables, columns, and domains
  • Setting up referential integrity
CREATE/ALTER/DROP TABLE
Chapter 7: Working with Indexes Creating and dropping indexes CREATE/ALTER/DROP INDEX
Chapter 8: Working with Views
  • Creating and dropping views
  • Using WITH CHECK OPTION
CREATE/DROP VIEW
Chapter 9: Working with Stored Procedures
  • Using stored procedures
  • What you can do with stored procedures
CREATE/ALTER/DROP PROCEDURE

CREATE/ALTER/DROP EXCEPTION

Chapter 10: Working with Triggers Using triggers, what you can do with triggers CREATE/ALTER/DROP TRIGGER

CREATE/ALTER/DROP EXCEPTION

Chapter 11: Working with Generators Creating, setting, and resetting generators CREATE GENERATOR

SET GENERATOR

Chapter 12: Planning Security Securing data and system catalogs with SQL: tables, views, triggers, and procedures GRANT, REVOKE
Chapter 13: Encrypting Your Data Encrypt database and/or specific columns in a database; create specific users and password types; grant and revoke encrypt and decrypt permissions. CREATE ENCRYPTION, ENCRYPT, DECRYPT
Chapter 14: Character Sets and Collation Orders Specifying character sets and collation orders CHARACTER SET COLLATE
Personal tools