O

object browser in Query Analyzer, 69

Object Explorer in SQL Server Management Stu- dio, 83–84

object reference, 449

OBJECT (reserved word), 466

Object Role Modeling (ORM), 33, 398

OBJECT_ID() function, 195, 477

OBJECT_NAME() function, 195, 477

object-oriented database management systems (ODBMS), 4

object-pooling, 409

OBJECTPROPERTY() function, 196, 477

object-relational database management systems (ORDBMS), 4–5

objects

altering, 121–122

dropping, 122–123

overview, 449

OCTET-LENGTH (reserved word), 464

ODBC (Open Database Connectivity)

overview, 402

reserved words in, 462–464

Odell, Margaret (Consensus Soundex), 302

OF (reserved word), 461, 464

OFF (reserved word), 461

OFFSETS (reserved word), 461

OLD (reserved word), 466

OLE automation procedures

sp_OACreate, 495

sp_OADestroy, 495

sp_OAGetErrorInfo, 495

sp_OAGetProperty, 495

sp_OAMethod, 495

sp_OASetProperty, 495

sp_OAStop, 495

ON (reserved word), 461, 464

one-to-exactly-one relationships, 15

one-to-many relationships, 14

one-to-one relationships, 14

one-to-zero relationships, 14

ONLY (reserved word), 464, 466

Open Database Connectivity (ODBC)

overview, 402

reserved words in, 462–464

OPEN (reserved word), 461, 464

OPENDATASOURCE (reserved word), 461

opening

Enterprise Manager, 50

SQL Server Management Studio, 74

OPENQUERY (reserved word), 461

OPENROWSET (reserved word), 461

OPENXML (reserved word), 461

OPERATION (reserved word), 466

operator precedence, 146–148

OPTION clause, 454

OPTION (reserved word), 461, 464

@@OPTIONS, 468–469

OR operator, 142, 319

OR (reserved word), 461, 464

Oracle, 19

ORDBMS (object relational database management systems), 4–5

ORDER BY clause, 150–152, 454

ORDER (reserved word), 461, 464

ORDINALITY (reserved word), 466

ORDINAL_POSITION view, 510, 513, 514

ORM (Object Role Modeling), 33, 398

OSQL utility, 70–72

OUT (reserved word), 466

outer join subqueries, 284–285

outer joins, 236–239

OUTER (reserved word), 461, 464

OUTPUT (reserved word), 464, 466

OVER (reserved word), 461

OVERLAPS (reserved word), 462

overriding constraints, 336

OWNER option, 344