摘要：select text from syscomments where id =(select id from sysobjects where name='vw_orderitem'--vw_orderitem为视图的名称)可以查询表名，视图名，存储过程名等select * from sysobjects --where xtype='U' --表名--where xtype='V' --视图名-... 阅读全文