diff --git a/console/src/components/Services/Data/RawSQL/Actions.js b/console/src/components/Services/Data/RawSQL/Actions.js
index d053dee918ee2..a6cc0b2e933fc 100644
--- a/console/src/components/Services/Data/RawSQL/Actions.js
+++ b/console/src/components/Services/Data/RawSQL/Actions.js
@@ -14,6 +14,7 @@ import returnMigrateUrl from '../Common/getMigrateUrl';
 
 const MAKING_REQUEST = 'RawSQL/MAKING_REQUEST';
 const SET_SQL = 'RawSQL/SET_SQL';
+const SET_CASCADE_CHECKED = 'RawSQL/SET_CASCADE_CHECKED';
 const SET_MIGRATION_CHECKED = 'RawSQL/SET_MIGRATION_CHECKED';
 const SET_TRACK_TABLE_CHECKED = 'RawSQL/SET_TRACK_TABLE_CHECKED';
 const REQUEST_SUCCESS = 'RawSQL/REQUEST_SUCCESS';
@@ -34,11 +35,12 @@ const executeSQL = isMigration => (dispatch, getState) => {
 
   const migrateUrl = returnMigrateUrl(currMigrationMode);
   const currentSchema = getState().tables.currentSchema;
+  const isCascadeChecked = getState().rawSQL.isCascadeChecked;
 
   let url = Endpoints.rawSQL;
   let requestBody = {
     type: 'run_sql',
-    args: { sql },
+    args: { sql: sql, cascade: isCascadeChecked },
   };
   // check if its a migration and send to hasuractl migrate
   if (isMigration) {
@@ -46,7 +48,7 @@ const executeSQL = isMigration => (dispatch, getState) => {
     const schemaChangesUp = [
       {
         type: 'run_sql',
-        args: { sql },
+        args: { sql: sql, cascade: isCascadeChecked },
       },
     ];
     // check if track view enabled
@@ -138,6 +140,8 @@ const executeSQL = isMigration => (dispatch, getState) => {
             } else {
               parsedErrorMsg.message = { error: parsedErrorMsg.error };
             }
+          } else if (parsedErrorMsg.code === 'dependency-error') {
+            parsedErrorMsg.message = errorMsg.error;
           }
           dispatch(
             showErrorNotification(
@@ -181,6 +185,8 @@ const rawSQLReducer = (state = defaultState, action) => {
       return { ...state, sql: action.data };
     case SET_MIGRATION_CHECKED:
       return { ...state, isMigrationChecked: action.data };
+    case SET_CASCADE_CHECKED:
+      return { ...state, isCascadeChecked: action.data };
     case SET_TRACK_TABLE_CHECKED:
       return {
         ...state,
@@ -234,6 +240,7 @@ export default rawSQLReducer;
 export {
   executeSQL,
   SET_SQL,
+  SET_CASCADE_CHECKED,
   SET_MIGRATION_CHECKED,
   SET_TRACK_TABLE_CHECKED,
   modalOpen,
diff --git a/console/src/components/Services/Data/RawSQL/RawSQL.js b/console/src/components/Services/Data/RawSQL/RawSQL.js
index b0dfa7c84f417..0fe578a0400c2 100644
--- a/console/src/components/Services/Data/RawSQL/RawSQL.js
+++ b/console/src/components/Services/Data/RawSQL/RawSQL.js
@@ -12,12 +12,19 @@ import Tooltip from 'react-bootstrap/lib/Tooltip';
 import {
   executeSQL,
   SET_SQL,
+  SET_CASCADE_CHECKED,
   SET_MIGRATION_CHECKED,
   SET_TRACK_TABLE_CHECKED,
 } from './Actions';
 import { modalOpen, modalClose } from './Actions';
 import globals from '../../../../Globals';
 
+const cascadeTip = (
+  <Tooltip id="tooltip-cascade">
+    Cascade all the dependent metadata references like relationships and
+    permissions.
+  </Tooltip>
+);
 const migrationTip = (
   <Tooltip id="tooltip-migration">
     Modifications to the underlying postgres schema should be tracked as
@@ -41,6 +48,7 @@ const RawSQL = ({
   lastError,
   lastSuccess,
   isModalOpen,
+  isCascadeChecked,
   isMigrationChecked,
   isTableTrackChecked,
   migrationMode,
@@ -194,6 +202,27 @@ const RawSQL = ({
             }}
           />
           <hr />
+          <div>
+            <input
+              checked={isCascadeChecked}
+              className={styles.add_mar_right_small}
+              id="cascade-checkbox"
+              type="checkbox"
+              onChange={() => {
+                dispatch({
+                  type: SET_CASCADE_CHECKED,
+                  data: !isCascadeChecked,
+                });
+              }}
+            />
+            Cascade relationships or permissions metadata
+            <OverlayTrigger placement="right" overlay={cascadeTip}>
+              <i
+                className={`${styles.padd_small_left} fa fa-info-circle`}
+                aria-hidden="true"
+              />
+            </OverlayTrigger>
+          </div>
           {migrationMode && globals.consoleMode === 'cli' ? (
             <div>
               <input
@@ -238,7 +267,9 @@ const RawSQL = ({
               </div>
               <hr />
             </div>
-          ) : null}
+          ) : (
+            <hr />
+          )}
           <button
             type="submit"
             className={styles.yellow_button}
diff --git a/console/src/components/Services/Data/RawSQL/State.js b/console/src/components/Services/Data/RawSQL/State.js
index 49b45c0a0672e..af4b3ef9ac57d 100644
--- a/console/src/components/Services/Data/RawSQL/State.js
+++ b/console/src/components/Services/Data/RawSQL/State.js
@@ -3,11 +3,11 @@ const defaultState = {
   ongoingRequest: false,
   lastError: null,
   lastSuccess: null,
-
   resultType: null,
   result: [],
   resultHeaders: [],
   isModalOpen: false,
+  isCascadeChecked: false,
   isMigrationChecked: false,
   isTableTrackChecked: false,
   showTrackTable: false,