mssql2005select count(*) from syscolumns where object_name(id)='表名'注意别拉了单引号
select count(*) from dba_tab_columns where owner='' and table_name='';
