Skip to content

Instantly share code, notes, and snippets.

@drewbanin

drewbanin/late_binding_views.sql

Last active January 8, 2018 20:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save drewbanin/4a7faf223398f8618a9828fb55d13519 to your computer and use it in GitHub Desktop.
Save drewbanin/4a7faf223398f8618a9828fb55d13519 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
late_binding_views.sql
create table public.test as (
select 1 as id
);
-- NOTE: This is a late binding view. Note the
-- "WITH NO SCHEMA BINDING" clause at the
-- end of the `create view` statement.
create view public.test_view as (
select * from public.test
) WITH NO SCHEMA BINDING;
drop table public.test;
-- DROP TABLE ✓
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment