I

IBM DB2, 19

IDENT_CURRENT() function, 201, 481

IDENT_INCR() function, 201, 481

identity, 37

@@IDENTITY, 204, 470

IDENTITY() function, 201, 481

identity keys, 30

IDENTITY property, 326–329

IDENTITY (reserved word), 460, 462

IDENTITYCOL (reserved word), 460

IDENTITY_INSERT (reserved word), 460

IDENT_SEED() function, 201, 481

@@IDLE, 204, 470

IF (reserved word), 460

IF statement, 380–382

IGNORE (reserved word), 464

image/text functions

overview, 192

PATINDEX() function, 475

TEXTPTR() function, 475

TEXTVALID() function, 475

IMMEDIATE (reserved word), 462, 465

implicit transactions, 254

Import and Export Data shortcut, 49

IN() function, 145–146, 287–288

IN (reserved word), 460, 462

INCLUDE (reserved word), 462

INDEX (reserved word), 460, 462

INDEX_COL() function, 195, 477

indexed views, 339–340

INDEXKEY_PROPERTY() function, 195, 477

INDEXPROPERTY() function, 195, 477

INDICATOR (reserved word), 462, 465

information schema views reference

CHECK_CONSTRAINTS view, 509

COLUMN_DOMAIN_USAGE view, 509–510

COLUMN_PRIVILEGES view, 510

COLUMNS view, 510–511

CONSTRAINT_COLUMN_USAGE view, 511

CONSTRAINT_TABLE_USAGE view, 511

DOMAIN_CONSTRAINTS view, 512

DOMAINS view, 512

KEY_COLUMN_USAGE view, 513

PARAMETERS view, 513

REFERENTIAL_CONSTRAINTS view, 513–514

ROUTINE_COLUMNS view, 514

ROUTINES view, 515–516

SCHEMATA view, 516

TABLE_CONSTRAINTS view, 517

TABLE_PRIVILEGES view, 517

TABLES view, 517

VIEW_COLUMN_USAGE view, 518

VIEWS view, 518

VIEW_TABLE_USAGE view, 518

information transformed into data, 33–34

Informix, 19–20

infrastructure investment, 399

INITIALIZE (reserved word), 465

INITIALLY (reserved word), 463, 465

INITIALLY_DEFERRED view, 512, 517

in-line comments, 113–114, 459

inline table-valued functions, 390–391

INNER JOIN statement, 235–236

inner join subqueries, 283–284

INNER (reserved word), 461, 463

INOUT (reserved word), 465

INPUT (reserved word), 463, 465

INSENSITIVE option, 297

INSENSITIVE (reserved word), 463

INSERT command, 257–258, 455

Insert procedure, 371–373

INSERT (reserved word), 461, 463

installation of Adventure Works Cycles database, 45

INT (reserved word), 463, 465

INTEGER (reserved word), 463, 465

intent locks, 18

INTERSECT command, 453

INTERSECT (reserved word), 461, 463

INTERVAL (reserved word), 463, 465

INTERVAL_PRECISION view, 515

INTERVAL_TYPE view, 515

INTO (reserved word), 461, 463

@@IO_BUSY, 204, 470

IS (reserved word), 461, 463

ISDATE() function, 201, 481

IS_DEFERRABLE view, 512, 517

IS_DETERMINISTIC view, 516

IS_GRANTABLE view, 510, 517

IS_IMPLICIITLY_INVOCABLE view, 516

IS_MEMBER() function, 200, 478

ISNULL() function, 201, 481

IS_NULLABLE view, 510, 514

IS_NULL_CALL view, 516

ISNUMERIC() function, 201, 481

ISOLATION (reserved word), 463, 465

IS_SRVROLEMEMBER() function, 200, 478

IS_UPDATABLE view, 518

IS_USER_DEFINED_CAST view, 516

ITERATE (reserved word), 465