Skip to main content

Manipulating Relationships and Indexes

Advanced SQL’s Data Definition Language Topics

  • Chapter
  • 315 Accesses

Abstract

Chapter 8 concentrates on creating and modifying tables using SQL, but creating the table is only part of the process. It stands to reason that you’ll also need to specify relationships between any tables that you create. Fortunately, Access does a good job of managing and enforcing relationships between tables and manipulating indexes.

This is a preview of subscription content, log in via an institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   49.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2002 Susan Sales Harkins and Martin W.P. Reid

About this chapter

Cite this chapter

Harkins, S.S., Reid, M.W.P. (2002). Manipulating Relationships and Indexes. In: SQL: Access to SQL Server. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-1573-8_9

Download citation

  • DOI: https://doi.org/10.1007/978-1-4302-1573-8_9

  • Publisher Name: Apress, Berkeley, CA

  • Print ISBN: 978-1-893115-30-9

  • Online ISBN: 978-1-4302-1573-8

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics