|
The following SQL can be used to query your database system tables for view DDL.
Sybase ASE
SELECT A.text
FROM syscomments A
WHERE A.id = Object_Id(:sView)
ORDER BY colid
Oracle
SELECT text, line
FROM all_source
WHERE type = 'VIEW'
AND owner = :sOwner
AND name = :sView
SQL Server
SELECT A.text
FROM syscomments A, sysobjects B
WHERE A.id = B.id
AND B.id = Object_Id(:sView)
ORDER BY colid
SQL Anywhere
SELECT A.text
FROM syscomments A
WHERE A.id = Object_Id(:sView)
ORDER BY colid
|
|
QweryBuilder is an SQL Editor and Query Tool. Its purpose is
to make accessing information from a database simple, quick, accurate and
efficient.
Work with your SQL Server, ASE, SQL Anywhere and Oracle databases in
one single application.
|
"QweryBuilder is a great, easy to use tool, that is a part of my everyday programmer life."
Read More Testimonials
|
|
|
