Interbase DataDef

Table of Contents......Page 3
List of Tables......Page 11
List of Figures......Page 13
What is data definition?......Page 15
Who should use this guide......Page 16
Topics covered in this guide......Page 17
Using a data definition file......Page 18
Overview of design issues......Page 21
Design goals......Page 22
Design framework......Page 23
Collecting and analyzing data......Page 24
Identifying entities and attributes......Page 25
Determining unique attributes......Page 28
Specifying a datatype......Page 29
Choosing international character sets......Page 30
Defining integrity constraints......Page 31
Establishing relationships between objects......Page 32
Enforcing referential integrity......Page 33
Normalizing the database......Page 34
Choosing indexes......Page 38
Increasing cache size......Page 39
Naming Objects......Page 40
What you should know......Page 41
Using CREATE DATABASE......Page 42
Altering a database......Page 47
Dropping a database......Page 48
Limitations of shadowing......Page 49
Using CREATE SHADOW......Page 50
Dropping a shadow......Page 54
Extracting a 3.x database......Page 55
About InterBase datatypes......Page 57
Where to specify datatypes......Page 60
Integer datatypes......Page 61
Fixed-decimal datatypes......Page 62
Floating-point datatypes......Page 67
Converting to the DATE, TIME, and TIMESTAMP datatypes......Page 69
Character datatypes......Page 70
Specifying a character set......Page 71
Fixed-length character data......Page 73
Variable-length character data......Page 74
BLOB columns......Page 75
BLOB segment length......Page 76
BLOB subtypes......Page 77
Defining arrays......Page 78
Multi-dimensional arrays......Page 79
Specifying subscript ranges for array dimensions......Page 80
Implicit type conversions......Page 81
Explicit type conversions......Page 82
Creating domains......Page 85
Specifying the domain datatype......Page 86
Specifying domain defaults......Page 87
Specifying domain CHECK constraints......Page 88
Using the VALUE keyword......Page 89
Altering domains with ALTER DOMAIN......Page 90
Dropping a domain......Page 91
Before creating a table......Page 93
Defining columns......Page 94
Defining integrity constraints......Page 100
Defining a CHECK constraint......Page 105
Using the EXTERNAL FILE option......Page 107
Before using ALTER TABLE......Page 111
Using ALTER TABLE......Page 113
Dropping a table......Page 118
DROP TABLE syntax......Page 119
Index basics......Page 121
Creating indexes......Page 122
Using CREATE INDEX......Page 123
When to use a multi-column index......Page 124
Examples using multi-column indexes......Page 125
Using ALTER INDEX......Page 126
Using SET STATISTICS......Page 127
Using DROP INDEX......Page 128
Introduction......Page 129
Creating views......Page 131
Using the SELECT statement......Page 132
Types of views: read-only and updatable......Page 133
Inserting data through a view......Page 134
Dropping views......Page 136
Overview of stored procedures......Page 137
Using a data definition file......Page 138
Calling stored procedures......Page 139
Creating procedures......Page 140
CREATE PROCEDURE syntax......Page 141
Procedure and trigger language......Page 142
The procedure header......Page 146
The procedure body......Page 148
Altering and dropping stored procedures......Page 157
Alter procedure syntax......Page 158
Altering and dropping procedures in use......Page 159
Using executable procedures in isql......Page 161
Using select procedures in isql......Page 162
Viewing arrays with stored procedures......Page 166
Altering exceptions......Page 168
Raising an exception in a stored procedure......Page 169
Handling exceptions......Page 170
Handling InterBase errors......Page 171
Examples of error behavior and handling......Page 172
About triggers......Page 177
Using a data definition file......Page 178
CREATE TRIGGER syntax......Page 179
InterBase procedure and trigger language......Page 181
The trigger header......Page 185
The trigger body......Page 186
Altering triggers......Page 188
Altering a trigger header......Page 189
Dropping triggers......Page 190
Using triggers......Page 191
Triggers as event alerters......Page 192
Updating views with triggers......Page 193
Raising an exception in a trigger......Page 195
Error handling in triggers......Page 196
About generators......Page 197
Setting or resetting generator values......Page 198
Using generators......Page 199
Overview of SQL access privileges......Page 201
Default security and access......Page 202
SQL ROLES......Page 203
Granting privileges to a whole table......Page 204
Granting privileges to a stored procedure or trigger......Page 206
Granting all privileges......Page 207
Granting privileges to multiple users......Page 208
Using roles to grant privileges......Page 209
Granting a role to users......Page 210
Grant authority restrictions......Page 211
Grant authority implications......Page 212
Granting access to views......Page 213
Updatable views......Page 214
Revoking user access......Page 216
Revocation restrictions......Page 217
Revoking privileges for a list of users......Page 218
Revoking a role from users......Page 219
Revoking privileges for all users......Page 220
Using views to restrict data access......Page 221
Character Sets and CollationOrders......Page 223
InterBase character sets......Page 224
Character sets for DOS......Page 228
Character sets for Microsoft Windows......Page 229
Specifying a default character set for a database......Page 230
Specifying a character set for a client connection......Page 231
Specifying collation order in a comparison operation......Page 232
Specifying collation order in a GROUP BY clause......Page 233
InterBase Document Conventions......Page 235
The InterBase documentation set......Page 236
Printing conventions......Page 237
Syntax conventions......Page 238
Index......Page 239