Using delimited identifiers  Using delimited identifiers within an object name

Chapter 4: Expressions, Identifiers, and Wildcard Characters

Identifying tables or columns by their qualified object name

You can uniquely identify a table or column by adding other names that qualify it—the database name, owner’s name, and (for a column) the table or view name. Each qualifier is separated from the next one by a period. For example:

database.owner.table_name.column_name
database.owner.view_name.column_name

The naming conventions are:

[[database.]owner.]table_name
[[database.]owner.]view_name




Copyright © 2005. Sybase Inc. All rights reserved. Using delimited identifiers within an object name

View this book as PDF