Previous Page | Next Page

SAS/ACCESS Interface to Sybase

Naming Conventions for Sybase

For general information about this feature, see SAS Names and Support for DBMS Names.

Sybase database objects include tables, views, columns, indexes, and database procedures. They follow these naming conventions.

By default, Sybase does not enclose column names and table names in quotations marks. To enclose these in quotation marks, you must use the QUOTED_IDENTIFIER= LIBNAME option when you assign a libref.

When you use the DATASETS procedure to list your Sybase tables, the table names appear exactly as they exist in the Sybase data dictionary. If you specified the SCHEMA= LIBNAME option, SAS/ACCESS lists the tables for the specified schema user name.

To reference a table or other named object that you own, or for the specified schema, use the table name--for example, CUSTOMERS. If you use the DBLINK= LIBNAME option, all references to the libref refer to the specified database.

Previous Page | Next Page | Top of Page