Category:Data Definition Guide
From InterBase
Pages in category "Data Definition Guide"
The following 200 pages are in this category, out of 243 total.
(previous page) (next page)A
- About Character Sets and Collation Orders
- About Generators
- About InterBase Data Types
- About InterBase Encryption
- About Text BLOB Syntax
- About Triggers
- Adding Comments
- Additional Guidelines for Encrypting and Decrypting Database Backup Files
- Advantages of Creating a Database Shadow
- Advantages of Views
- ALTER INDEX: Deactivating an Index
- ALTER PROCEDURE syntax
- Altering a Database
- Altering a Global Temporary Table
- Altering a Trigger Body
- Altering a Trigger Header
- Altering and Dropping Procedures in Use
- Altering and Dropping Stored Procedures
- Altering Domains
- Altering Stored Procedures
- Altering Tables
- Altering Triggers
- Analyzing Requirements
- Avoiding Embedded Spaces in GBAK Encrypt/Decrypt and Sep Statements
B
C
- Change Views
- Change Views Glossary
- Character Set Storage Requirements
- Character Sets and Collation Orders
- Character Sets for DOS
- Choosing Indexes
- Choosing International Character Sets
- Collecting and Analyzing Data
- Converting Data Types
- Create an Encrypted Key
- CREATE PROCEDURE syntax
- CREATE TRIGGER Syntax
- Creating a Database (Data Definition Guide)
- Creating a Database Shadow
- Creating a Database Using a Data Definition File
- Creating a Global Temporary Table
- Creating a Multifile, Distributed Database
- Creating Databases (Data Definition Guide)
- Creating Domains (Data Definition Guide)
- Creating Encryption Keys
- Creating Generators
- Creating Indexes
- Creating Nested and Recursive Procedures
- Creating Procedures
- Creating Read-only Databases
- Creating Tables (Data Definition Guide)
- Creating Triggers
- Creating Views (Data Definition Guide)
D
- Database File Naming Conventions
- Date and Time Data Types
- Decrypting a Database Backup File During a Restore
- Decrypting Data
- Decrypting the Database
- Default Security and Access
- Defining a CHECK Constraint
- Defining Arrays
- Defining BLOB Data Types
- Defining CHECK Constraints
- Defining Columns
- Defining Integrity Constraints
- Defining Integrity Constraints on a Table
- Defining Numeric Data Types
- Design Framework
- Designing Databases
- Designing Tables
- Determining Unique Attributes (Designing Databases)
- Developing a Set of Rules (Designing Databases)
- Drop Encryption with IBConsole
- Drop Procedure Syntax
- Dropping a Database
- Dropping a Domain
- Dropping a Shadow (Creating Databases)
- Dropping a User-defined Index
- Dropping Generators
- Dropping Procedures
- Dropping Tables
- Dropping Triggers
- Dropping Views
E
- Enabling EUA and Performing Encryption on an Existing Database
- Enabling EUA and Performing Encryption When Creating a New Database
- Encrypting a Database Backup File
- Encrypting a Database with IBConsole
- Encrypting Backup Files
- Encrypting Data
- Encrypting Your Data
- Enforcing Referential Integrity
- Error Handling in Triggers
- Establishing Relationships between Objects
- Examples of Error Behavior and Handling
- Examples Using Multi-column Indexes
- Expanding the Size of a Shadow
- Expression Index
G
- Global Temporary Tables
- Grant Authority Implications
- Grant Authority Restrictions
- Granting Access to Columns in a Table
- Granting Access to Views
- Granting all Privileges
- Granting Decrypt Permission
- Granting Encryption Permission to the Database Owner
- Granting Multiple Privileges
- Granting Privileges
- Granting Privileges to a List of Procedures
- Granting Privileges to a Stored Procedure or Trigger
- Granting Privileges to a Whole Table
- Granting Privileges to Execute Stored Procedures
- Granting Privileges to Multiple Users
- Granting Users the Right to Grant Privileges
I
P
R
- Raising an Exception in a Trigger
- Read-only Views
- Requirements and Constraints (Global Temporary Tables)
- Restore an Encrypted Database
- Revocation Restrictions
- Revoking a Role from Users
- Revoking All Privileges
- Revoking Encrypt and Decrypt Permissions
- Revoking EXECUTE Privileges
- Revoking Grant Authority
- Revoking Multiple Privileges
- Revoking Privileges for a Fole
- Revoking Privileges for a List of Users
- Revoking Privileges for All Users
- Revoking Privileges from Objects
- Revoking User Access
S
- Selecting Aggregates from Procedures
- SET STATISTICS: Recomputing Index Selectivity
- Setting Default Values and NULL Status
- Setting or Resetting Generator Values
- Setting the System Encryption Password (SEP)
- Specifying a Data Type
- Specifying Collation Orders
- Specifying Data Types
- Specifying Defaults
- Specifying Domain CHECK Constraints
- Specifying Domain Collation Order
- Specifying Domain Defaults
- Specifying Domains
- Specifying NOT NULL
- Specifying Subscript Ranges for Array Dimensions
- Specifying the Domain Data Type
- Specifying View Column Names
- SQL ROLES
- Stored Procedure Exceptions
- Syntax Errors in Triggers