sysdatabases

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

name

sysname

30

No

2

dbid

smallint

2

No

3

suid

int

4

No

4

status

smallint

2

No

5

version

smallint

2

No

6

logptr

int

4

No

7

crdate

datetime

8

No

8

dumptrdate

datetime

8

No

9

status2

smallint

2

Yes

10

audflags

int

4

Yes

11

deftabaud

int

4

Yes

12

defvwaud

int

4

Yes

13

defpraud

int

4

Yes

14

def_remote_type

smallint

2

Yes

15

def_remote_loc

varchar

255

Yes

16

status3

int

4

Yes

17

status4

int

4

Yes

Name

Attributes

Segment

Columns

sysdatabases

unique
clustered

system

name

ncsysdatabases

unique

system

dbid

#

Columns

1

name

1

sp_commonkey references table syslocks.
Column dbid to syslocks.dbid

2

sp_commonkey references table syslogins.
Column suid to syslogins.suid

3

sp_commonkey references table sysprocesses.
Column dbid to sysprocesses.dbid

4

sp_commonkey references table sysusages.
Column dbid to sysusages.dbid

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

0x0F0FFE

dbo

2

sso_role

grant

select

All

dbo