select a.name,a.length,a.isnull,a., a.usertype ,c.name
from syscolumns a,
sysobjects b ,
systypes c
where a.id=b.id
and b.name='pub_info'
and a.usertype=c.usertype
select column_name from all_tab_columns
where owner='用户1' and table_name='表名1'
and column_name not in
select column_name from all_tab_columns
where owner='用户2' and tablename='表名2'
注;求出是表名1多出表名2的字段列表
sql server的
不完全,你自己再查查帮助
select a.* from syscolumns a, sysobjects b
where a.id=b.id and b.name='pub_info'