刹那的菜鸟

博客园 首页 新随笔 联系 管理

SELECT b.name as TableName,a.name as columnname
From syscolumns a
INNER JOIN sysobjects b ON a.id=b.id
where b.type='U'
AND a.name like 'store%'

posted on 2017-11-08 17:00  刹那的菜鸟  阅读(873)  评论(0编辑  收藏  举报