This repository has been archived by the owner on Jun 29, 2021. It is now read-only.

DROP STAR SCHEMA

Jump to bottom

ali1rathore edited this page Sep 10, 2018 · 1 revision

Grammar

DROP STAR SCHEMA [ON] <fact-table>

Description

Command to drop a StarSchema on a FactTable.

###Checks

StarSchema cannot be dropped, if there are SNAP Indexes defined on the Fact Table.

Examples

drop star schema on lineitem_small