#11793: Support for MATERIALIZED VIEW in Sybase Anywhere

dutondeumesh reported 2014-02-28T12:19:09Z · last modified 2014-05-23T19:52:41Z

Dev	JohnLH
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	App - Visual Editing
Version	Future - .9

Aqua Data Studio 15.0.0-dev-134

Build #: 36374

Built on: 2014-Feb-27 05:32:15 PM

OS: Windows 8, 64 bit

Database: Sybase Anywhere 12

Steps to reproduce:

Connect to Sybase Anywhere

Create table and materialized view (execute below scripts)

CREATE TABLE DBA.Person_a (

id integer NULL,

first_name varchar(150) NULL,

last_name varchar(150) NULL,

country varchar(150) NULL,

age integer NULL

)

set ansinull on

CREATE MATERIALIZED VIEW Employee_a AS

SELECT first_name,country

FROM Person_a

Materialized view created successfully.

All Comments (0) Change History