是否有保存sysobjects.xtype描述上市的表？(Is there a table that

据的系统对象的文档 ， sysobjects.xtype可以是这些对象类型中的一种：

| xtype |              Description              |
|-------|---------------------------------------|
| AF    |  Aggregate function (CLR)             |
| C     |  CHECK constraint                     |
| D     |  Default or DEFAULT constraint        |
| F     |  FOREIGN KEY constraint               |
| L     |  Log                                  |
| FN    |  Scalar function                      |
| FS    |  Assembly (CLR) scalar-function       |
| FT    |  Assembly (CLR) table-valued function |
| IF    |  In-lined table-function              |
| IT    |  Internal table                       |
| P     |  Stored procedure                     |
| PC    |  Assembly (CLR) stored-procedure      |
| PK    |  PRIMARY KEY constraint (type is K)   |
| RF    |  Replication filter stored procedure  |
| S     |  System table                         |
| SN    |  Synonym                              |
| SQ    |  Service queue                        |
| TA    |  Assembly (CLR) DML trigger           |
| TF    |  Table function                       |
| TR    |  SQL DML Trigger                      |
| TT    |  Table type                           |
| U     |  User table                           |
| UQ    |  UNIQUE constraint (type is K)        |
| V     |  View                                 |
| X     |  Extended stored procedure            |

我可以把这些变成一个CASE语句，但有一个表，我可以快快加入到该查找xtype描述？ 我知道systypes是不是该表。 我的意思是，我只是有种记住了很多人，但我做了一些研究的数据库，它是外国对我来说（即我不知道一吨左右的话），所以我想建这说明进入该查询没有CASE语句：

select object_name(c.id), c.name, [length], o.xtype from syscolumns c
    join sysobjects o on o.id = c.id
where c.name like '%job%code%'

Update

下面是SQLMenace答案后的最终结果。 我觉得有必要在这里地方，因为它不只是一个简单的join 。

select object_name(c.id), c.name, t.name, c.[length], o.xtype, x.name from syscolumns c
    join sysobjects o on o.id = c.id
    join systypes t on t.xtype = c.xtype
    join master..spt_values x on x.name like '%' + o.xtype + '%' and x.type = 'O9T'
where c.name like '%job%code%'
order by c.xtype

Answer 1:

有这

SELECT name 
FROM master..spt_values
WHERE type = 'O9T'

产量

AF: aggregate function
AP: application
C : check cns
D : default (maybe cns)
EN: event notification
F : foreign key cns
FN: scalar function
FS: assembly scalar function
FT: assembly table function
IF: inline function
IS: inline scalar function
IT: internal table
L : log
P : stored procedure
PC : assembly stored procedure
PK: primary key cns
R : rule
RF: replication filter proc
S : system table
SN: synonym
SQ: queue
TA: assembly trigger
TF: table function
TR: trigger
U : user table
UQ: unique key cns
V : view
X : extended stored proc
sysobjects.type, reports

Answer 2:

以下是我想出了获得总数据库对象及其说明。

    select xtype1, Description, total_count, last_crdate, last_refdate 
    from 
    (SELECT xtype as xtype1, total_count = COUNT(*), last_crdate = MAX(crdate), last_refdate = MAX(refdate)
     FROM sysobjects 
     GROUP BY xtype
     )o
    left outer join 
    (SELECT LEFT(name,PATINDEX('%:%',name)-1) AS xtype2, RIGHT(name, (LEN(name) - PATINDEX('%:%',name))) AS Description
    FROM master..spt_values 
    WHERE type = 'O9T' AND number  = -1
    )x 
    on o.xtype1 = x.xtype2
    order by Description;

文章来源: Is there a table that holds the listing of sysobjects.xtype descriptions?