Using qualified identifiers consistently  Renaming database objects

Chapter 4: Expressions, Identifiers, and Wildcard Characters

Determining whether an identifier is valid

Use the system function valid_name, after changing character sets or before creating a table or view, to determine whether the object name is acceptable to Adaptive Server. Here is the syntax:

select valid_name("Object_name")

If object_name is not a valid identifier (for example, if it contains illegal characters or is more than 30 bytes long), Adaptive Server returns 0. If object_name is a valid identifier, Adaptive Server returns a nonzero number.





Copyright © 2005. Sybase Inc. All rights reserved. Renaming database objects

View this book as PDF