Data Definition Guide

From InterBase

Go Up to User Guides


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

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

Chapters

Chapter list for the Data Definition Guide
Chapter Description Topics SQL statements
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
CREATE/ALTER/DROP DATABASE
Designing Databases
  • Planning and designing a database
  • Understanding data integrity rules and using them in a database
  • Planning physical storage
Creating Databases Creating an InterBase database

CREATE/ALTER/DROP DATABASE

CREATE/ALTER/DROP SHADOW

Specifying Data Types Choosing a data type

CREATE/ALTER TABLE

CREATE/ALTER DOMAIN

Working with Domains Creating, altering, and dropping domains CREATE/ALTER/DROP DOMAIN
Working with Tables
  • Creating and altering database tables, columns, and domains
  • Setting up referential integrity
CREATE/ALTER/DROP TABLE
Working with Indexes Creating and dropping indexes CREATE/ALTER/DROP INDEX
Working with Views
  • Creating and dropping views
  • Using WITH CHECK OPTION
CREATE/DROP VIEW
Working with Change Views
  • Finding what data has changed since it was last viewed
Working with Stored Procedures
  • Using stored procedures
  • What you can do with stored procedures

CREATE/ALTER/DROP PROCEDURE

CREATE/ALTER/DROP EXCEPTION

Working with Triggers Using triggers, what you can do with triggers

CREATE/ALTER/DROP TRIGGER

CREATE/ALTER/DROP EXCEPTION

Working with Generators Creating, setting, and resetting generators

CREATE GENERATOR

SET GENERATOR

Planning Security Securing data and system catalogs with SQL: tables, views, triggers, and procedures


GRANT, REVOKE
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
Character Sets and Collation Orders Specifying character sets and collation orders CHARACTER SET ­COLLATE