chinaitv的专栏

SELECT count(*) FROM sysobjects WHERE XTYPE='u'

select count(name) from syscolumns where id=(select id from sysobjects where xtype='u' and name='表名')

declare @date1 datetimedeclare @date2 datetimeselect @date1=getdate()--测试语句写在这里select @date2=getdate()select datediff(millisecond, @date1, @date2) --执行上面的代码，结果是毫秒数

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