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%'
转载于:https://www.cnblogs.com/zxs-onestar/p/7804972.html
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%'
转载于:https://www.cnblogs.com/zxs-onestar/p/7804972.html