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 the SAP ASE server.

The syntax is:

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), the SAP ASE server returns 0. If object_name is a valid identifier, the SAP ASE server returns a nonzero number.