syscomments

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

id

int

4

No

2

number

smallint

2

No

3

colid

smallint

2

No

4

texttype

smallint

2

No

5

language

smallint

2

No

6

text

varchar

255

Yes

7

colid2

smallint

2

No

8

status

smallint

2

Yes

Name

Attributes

Segment

Columns

syscomments

unique
clustered

default

id, number, colid2, colid, texttype

#

Columns

1

id
number
colid2
colid
texttype

1

sp_commonkey references table sysobjects.
Column id to sysobjects.id

1

sp_commonkey coming from table syscolumns.
syscolumns.id to column id

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

All

dbo