请问谁知道smallid是哪个系统表的字段？马上给分。

Question

select name from sysobjects A where exists (select 1 from syscolumns  where id=A.id and name='smallid' )

Answer 1

查找不到呀。left join sysproperties gon a.id=g.id AND a.colid = g.smallid  我上面这条语句提示sysproperties错误，能给分析一下么？

Answer 2

sysproperties在库里找不到，为什么？

Answer 3

select * from sysobjects where xtype='s'
可找到'sysproperties'

Answer 4

下面是查询的结果，没有啊。我用的7.0
name                                                                                                                             
-------------------------------------------------------------------------------------------------------------------------------- 
sysobjects
sysindexes
syscolumns
systypes
syscomments
sysfiles1
syspermissions
sysusers
sysdepends
sysreferences
sysfulltextcatalogs
sysindexkeys
sysforeignkeys
sysmembers
sysprotects
sysdatabases
sysperfinfo
sysprocesses
sysxlogins
syslocks
sysdevices
sysmessages
sysconfigures
syscurconfigs
sysservers
syslockinfo
syslanguages
syscharsets
syscursorrefs
syscursors
syscursorcolumns
syscursortables
syscacheobjects
sysaltfiles
sysfiles
sysfilegroups
sysallocations
SYSREMOTE_COLUMNS
SYSREMOTE_INDEXES
SYSREMOTE_STATISTICS
SYSREMOTE_PROVIDER_TYPES
SYSREMOTE_TABLE_PRIVILEGES
SYSREMOTE_COLUMN_PRIVILEGES
SYSREMOTE_CATALOGS
SYSREMOTE_SCHEMATA
SYSREMOTE_TABLES
SYSREMOTE_VIEWS
SYSREMOTE_PRIMARY_KEYS
SYSREMOTE_FOREIGN_KEYS(49 row(s) affected)