例如:求表"A" 的总列数,通过以下两张系统表可以求出
SYSOBJECTS
SYSCOLUMNS
select
syscolumns.name
from
sysobjects,
syscolumns
where
sysobjects.id = syscolumns.id
and sysobjects.name ='A'
例如:求表"A" 的总列数,通过以下两张系统表可以求出
SYSOBJECTS
SYSCOLUMNS
select
syscolumns.name
from
sysobjects,
syscolumns
where
sysobjects.id = syscolumns.id
and sysobjects.name ='A'