select a.Name from (Select Object_Id(Name)as id,Name FROM SysObjects Where XType='U') as a,SysColumns where a.id=SysColumns.id and SysColumns.Name=字段名这样就行了~追问
在我完全不知道那种表里有什么的情况下。。。可以吗。。。
本回答被网友采纳
第2个回答 2015-07-31
public class Springusercontroller extends AbstractCommandController{ private String page; private String error; private IuserinfoService service;本回答被网友采纳
第3个回答 2017-08-21
select colname from syscolumns where tabid = (select tabid from systables where tabname = '表名');