查找存在某些字段的用户表和视图

    技术2022-05-11  27

    [sql server] select name,case when xtype='u' then 'usertable' else 'userview' end as xtype from sysobjects where id in ( select id from syscolumns where name in('商品编号','商品名称') ) and (xtype='u' or xtype='v') order by xtype

    最新回复(0)