Table 2-13: Changes to system table columns
System catalog
|
Changed column
|
Datatype changes
|
Identifier name
|
|---|
sysattributes
|
object_cinfo
char_info
|
varchar(30) null to varchar(255)
null
varchar(255) to varchar(768)
|
Identifier for the object
|
sysaudits01-sysaudits08
|
objname
|
varchar(30) not null to varchar(255)
not null
|
Object name
|
syscolumns
|
name
|
varchar(30) not null to varchar(255)
not null
|
Column name
|
|
remote_name
|
varchar(30) null to varchar(255)
null
|
Maps local names to remote names
|
sysconfigures
|
name
|
varchar(80) null to varchar(255)
null
|
|
sysindexes
|
name
|
varchar(30) null to varchar(255)
null
|
Index for the table name
|
sysjars
|
jname
|
varchar(30) null to varchar(255)
null
|
JAR name
|
sysobjects
|
name
|
varchar(30) not null to varchar(255)
not null
|
Object name
|
sysprocesses
|
hostname
|
char(10) not null to varchar(30)
null
|
Host computer name
|
|
program_name
|
char(16) not null to varchar(30)
null
|
Name of front_end module
|
|
hostprocess
|
char(8) not null to varchar(30)
null
|
Host process ID number
|
|
cmd
|
char (16) not null to varchar(30)
null
|
Command or process currently being executed. Evaluation
of a conditional statement, such as an if or while loop, returns.
|
systimeranges
|
name
|
varchar(30) not null to varchar(255)
not null
|
Unique name of the time range
|
systypes
|
name
|
varchar(30) to varchar(255)
|
Datatype name
|
sysdatabases:
|
def_remote_loc
|
varchar(255) null to varchar(349)
null.
|
|
