The timestamp datatype  Converting between datatypes

Chapter 6: Using and Creating Datatypes

The sysname and longsysname datatype

sysname and longsysname are user-defined datatypes used in the system tables. sysname is defined as:

varchar(30) "NOT NULL"

longsysname is defined as:

varchar(255) "NOT NULL"

You can declare a column, parameter, or variable to be of type sysname or . Alternately, you can also create a user-defined datatype with a base type of sysname or longsysname.

You can then use this user-defined datatype to create columns. For more information, see “Creating user-defined datatypes”.





Copyright © 2005. Sybase Inc. All rights reserved. Converting between datatypes

View this book as PDF