 |
|
| SAS/ACCESS Interface to Microsoft SQL Server |
Naming Conventions for Microsoft SQL Server
For general information about this feature, see SAS Names and Support for DBMS Names.
The PRESERVE_COL_NAMES= and PRESERVE_TAB_NAMES= LIBNAME options determine how SAS/ACCESS Interface to Microsoft SQL Server handles case sensitivity, spaces, and special characters. (For information about these options, see Overview of the LIBNAME Statement for Relational Databases.) The default value for both of these options is YES for Microsoft Access, Microsoft Excel, and Microsoft SQL Server; NO for all others. For additional information about these options, see Overview of the LIBNAME Statement for Relational Databases.
Microsoft SQL Server supports table names and column names that contain up to 32 characters. If DBMS column names are longer than 32 characters, SAS truncates them to 32 characters. If truncating a column name would result in identical names, SAS generates a unique name by replacing the last character with a number. DBMS table names must be 32 characters or less because SAS does not truncate a longer name. If you already have a table name that is greater than 32 characters, it is recommended that you create a table view.
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.