select distinct sysobjects.[name] as [tblname], syscolumns.colid, syscolumns.[name] as [colname]
from syscolumns, sysobjects where sysobjects.id=syscolumns.id and sysobjects.[name]='gbook'
只要改一下最后的表名就OK了
select distinct sysobjects.[name] as [tblname], syscolumns.colid, syscolumns.[name] as [colname]
from syscolumns, sysobjects where sysobjects.id=syscolumns.id and sysobjects.[name]='gbook'
只要改一下最后的表名就OK了