What is tid ?

[ykfc]

Examining the properties of the table sales in the pubs sample database (MS SQL 2000), I notice the salesID column has the data type tid. What is that? I read the chapter "data type" in BOL but get nowhere.

 

[hmckillop]

it probably is a custom data type, without having access to a pubs db at the minute, this is justa guess, but if you do

select column_name, data_type, domain_name from information_schema.columns where table_name = 'sales'

it will show you the actual data type and the custom data type

"I'm living so far beyond my income that we may almost be said to be living apart

 

[vongrunt]

Alternatively you can drill down EM and expand 'User Defined Data Types' node.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)