sysconfigures

Columns for sysconfigures

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

config

smallint

2

 

 

No

 

 

 

2

value

int

4

 

 

No

 

 

 

3

comment

varchar

255

 

 

No

 

 

 

4

status

int

4

 

 

No

 

 

 

5

name

varchar

80

 

 

Yes

 

 

 

6

parent

smallint

2

 

 

Yes

 

 

 

7

value2

varchar

255

 

 

Yes

 

 

 

8

value3

int

4

 

 

Yes

 

 

 

9

value4

int

4

 

 

Yes

 

 

 

 

Indexes for sysconfigures

Name

Attributes

Segment

Columns

csysconfigures

unique
clustered

default

name, parent, config

nc1sysconfigures

 

default

parent, config

nc2sysconfigures

 

default

config

 

sp_primarykey defined for sysconfigures

#

Columns

1

config

 

Incoming sp_commonkeys coming into sysconfigures

1

sp_commonkey coming from table syscurconfigs.
syscurconfigs.config to column config

 

Permissions on sysconfigures

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

All

dbo

 


Go to Sybase 12.5 Master DB System Tables.


Updated: Sun Sep 29 12:56:19 2002