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. |