Download This File Rate This File your rating12345678910 Shopping v 1.01 Products Compare Products,Prices and Stores Shop by Category: Routers - 1 Model Matches Personal Care - 0 Store Offers Lighting - 2 Store Offers

content_start
Description:
Create or modify views for WATCOM SQL and Sybase SQL.

The database stores the definition of a view in the system table SYS.SYSTABLE in the column view_def in the form of a CREATE VIEW... command. Also SQL Central for Sybase SQL Anywhere and PowerBuilder show the definitions of the database views in this form. With slightly more complicated views (an expression or subquery in the columns' definition), this form is not very easy to read. And even a trivial modification of such a view - e.g. a change in the columns' order - means to get the CREATE VIEW... string, then modify it in a text editor, drop the original view and finally re-run the CREATE VIEW... command. The aim of this program is to simplify the work of a designer or a database administrator when modifying views. content_stop

Click on the icon below to download this file: