Syscolumns.Status

Question

Post reply

Syscolumns.Status

stingrae

Old Hand

Points: 369
More actions
September 2, 2005 at 9:49 am

#168590

Hi,

does anyone have any information or documentation on what the values for syscolumns.status are?
for instance, i know that a value of 8 is NullValues are Allowed, 10 is ANSI Padding, and 128 means it is an Identity columns.
But there are many others like 9, 56 that I cannot figure out.
Any help would be appreciated.
cheers.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

9 = 8 + 1

56 = 32 + 16 + 8

Check out all those attributes, those are cumulative for a single column.

stingrae Old Hand Points: 369 More actions · Answer 2

hey, thanks for the quick reply. i figured it was something like that as i saw the 24 was 8 + 16.

and sorry if this next question is a bit elementary, but are you able to enlighten me as to the decimal values of all the base numbers used. for instance i found this in the microsoft documention:

Bitmap used to describe a property of the column or the parameter:

0x08 = Column allows null values.

0x10 = ANSI padding was in effect when varchar or varbinary columns were added. Trailing blanks are preserved for varchar and trailing zeros are preserved for varbinary columns.

0x40 = Parameter is an OUTPUT parameter.

0x80 = Column is an identity column.

do you have access to a table that lists all the 0xYY values that syscolumns uses?

cheers

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

little conversion info :

0x08 = 8

0x10 = 10

0x40 = 64

0x80 = 128

err, wrong answer.

I don't think there is... but I haven't searched that info long.

stingrae Old Hand Points: 369 More actions · Answer 4

yeah, this is all i can find ....

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys-o_4zll.asp

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

Pretty much all I had... you'll have to trust non microsoft sources on this one. But I guess building you're own table after that wouldn't be much of a problem .