如何通过sql语句比较2个表结构

如何通过sql语句比较2个表结构

如果是Oracle数据库的话，可以按以下语句比较
select v1.table_name,v2.table_name, v1.column_name,v2.column_name,
v1.data_type,v2.data_type,v1.data_length,v2.data_length ,v1.data_precision,v2.data_precision,v1.data_scale,v2.data_scale
from
(select * from user_tab_columns where table_name='表1') v1 full join
(select * from user_tab_columns where table_name='表2') v2 on v1.column_name=v2.column_name

如果是sql server 2005以上的,可以用except运算

select  * from a

except

select * from b

union

(select * from b

 except

select * from a

)

通用的

select * from a where not exists(select * from b where b.pid=a.pid and b.name=a.name)

union

select * from b where not exists(select * from a where b.pid=a.pid and b.name=a.name)