Data Definition Guide

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