GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — [FEATURE] additional modifiers for CREATE VIEW · Issue #1959 · JSQLParser/JSqlParser

[FEATURE] additional modifiers for CREATE VIEW #1959

New issue
Copy link
New issue
Copy link
Closed
#1964
Closed
[FEATURE] additional modifiers for CREATE VIEW#1959
#1964
Copy link

Description

@davidjgoss
davidjgoss
opened on Feb 7, 2024
Issue body actions

Grammar or Syntax Description

Snowflake's CREATE VIEW includes standard modifiers but also:

  • SECURE
  • VOLATILE (alias for TEMPORARY)

SQL Example

CREATE OR REPLACE SECURE VIEW MY_VIEW AS SELECT COLUMN_1 FROM MY_TABLE;

CREATE VOLATILE VIEW MY_VIEW AS SELECT COLUMN_1 FROM MY_TABLE;

Additional context

  • JSQLParser 4.8
  • Snowflake
  • Syntax docs https://docs.snowflake.com/en/sql-reference/sql/create-view

Activity

  1. manticore-projects
    closed this as completedin #1964on Feb 13, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

      You are visitor 01402520 — GeezerVison does not store the pages you look up.
      Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.