求Java的数据库视图相关 *** 作代码

创建视图 CREATE VIEW VIEW_name    AS   SELECT empno, ename, sal, deptno FROM emp WHERE deptno = 10

删除视图 drop VIEW VIEW_name

查询视图 SELECT id, name, salary FROM VIEW_name

SQL Server

select

a.name AS ViewName,

c.text AS CreateViewSQL

from

sys.views a

LEFT OUTER JOIN

dbo.syscomments c ON a.object_id = c.id

order by

a.name

MySQL

是否是视图 通过 table_type 字段是否为 VIEW 来区分的。

SELECT

table_name AS `视图名`,

table_type AS `类型`,

engine AS `引擎`,

table_comment AS `备注`

FROM

information_schema.tables

WHERE

table_schema = 'test' AND table_type = 'VIEW'

ORDER BY

table_name DESC

存储过程

SQL Server

select

pro.name AS ProcedureName,

c.text AS CreateProcedureSQL

from

sys.procedures pro LEFT OUTER JOIN

dbo.syscomments c ON pro.object_id = c.id

MySQL 里面，查存储过程的，我这里暂时没有。