sql查询所有表的列名
摘要:
有时在一个库里一个字段 很麻烦找了一下午 弄出个语句SELECT sysobjects.name as Table_name, syscolumns.name AS Column_nameFROM ZY_DC.sys.syscolumns INNER JOINsysobjects ON syscolumns.id = sysobjects.idWHERE (syscolumns.name like '%a%') and (sysobjects.xtype = 'u') AND (NOT (sysobjects.name LIKE 'dtpropertie 阅读全文
posted @ 2012-01-29 21:28 刀齿 阅读(790) 评论(0) 推荐(0)
浙公网安备 33010602011771号