例如想读取的VIEW名称 MYVIEW
在ORACLE中:
SELECT TEXT FROM USER_VIEWS WHERE VIEW_NAME ='MYVIEW'
在SQL Server中:
SELECT definition FROM sysobjects a,sys.all_sql_modules b WHERE a.id = b.object_id and name ='MYVIEW'
在SyBase中:
SELECT b.text FROM sysobjects a,syscomments b WHERE a.id = b.id and
a.name ='MYVIEW'
特别提示:
Oracle中的返回是查询语句部分
SQL Server返回的是 "CREATE VIEW MYVIEW AS " + 查询语句部分 .如果有换行,换行符号也包含在里边