File: alter_datashare.sql

package info (click to toggle)
sqlfluff 3.5.0-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 34,000 kB
  • sloc: python: 106,131; sql: 34,188; makefile: 52; sh: 8
file content (15 lines) | stat: -rw-r--r-- 466 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 
ALTER DATASHARE salesshare SET PUBLICACCESSIBLE FALSE;

ALTER DATASHARE salesshare SET INCLUDENEW = TRUE FOR SCHEMA public;

ALTER DATASHARE salesshare ADD TABLE public.tbl1;

ALTER DATASHARE salesshare ADD TABLE public.tbl1, public.tbl2;

ALTER DATASHARE salesshare ADD SCHEMA public;

ALTER DATASHARE salesshare ADD FUNCTION public.fn1, public.fn2;

ALTER DATASHARE salesshare ADD ALL TABLES IN SCHEMA public;

ALTER DATASHARE salesshare REMOVE TABLE public.tbl1;