Informix Guide to SQL: Tutorial
Chapter 9: Implementing Your Data Model
Home
Contents
Index
Master Index
New Book
Implementing Your Data Model
Defining Column-Specific Properties
Extended Data Types
Built-In Data Types
Choosing a Data Type
Numeric Data Types
Chronological Data Types
Boolean Data Type
Character Data Types
Large Object Data Types
Changing the Data Type
Null Values
Default Values
Check Constraints
Domains
Creating a Domain
Dropping a Domain
Creating the Database
Using CREATE DATABASE
Using CREATE DATABASE with INFORMIX-Universal Server
Using CREATE TABLE
Using Command Scripts
Capturing the Schema
Executing the File
An Example
Populating the Tables
Fragmenting Tables and Indexes
Creating a Fragmented Table
Fragmenting a New Table
Creating a Fragmented Table from Nonfragmented Tables
Creating a Table from More Than One Nonfragmented Table
Creating a Fragmented Table from a Single Nonfragmented Table
Modifying a Fragmented Table
Modifying Fragmentation Strategies
Using the MODIFY Clause to Change a Fragmentation Strategy
Adding a New Fragment
Using the INIT Clause to Reinitialize a Fragmentation Scheme Completely
Dropping a Fragment
Accessing Data Stored in Fragmented Tables
Using Primary Keys Instead of Rowids
Rowid in a Fragmented Table
Creating a Rowid Column
Granting and Revoking
Summary
Informix Guide to SQL: Tutorial
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
