File: drop.sch

package info (click to toggle)
pgmodeler 1.2.2-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 14,160 kB
  • sloc: cpp: 99,216; xml: 27; sh: 15; makefile: 6
file content (31 lines) | stat: -rw-r--r-- 739 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
# SQL command to drop an object
# CAUTION: Do not modify this file unless you know what you are doing.
# Code generation can be broken if incorrect changes are made.

@include "ddlend"

%if %not {domain} %and {constraint} %or {column} %then
	%if %not {decl-in-table} %then
		[ALTER TABLE ] {table} [ DROP ] {sql-object} [ IF EXISTS ]
	%end
%else
	[DROP ] {sql-object} [ IF EXISTS ]
%end

%if {column} %or {constraint} %and %not {decl-in-table} %or {extension} %or {rule} %or {trigger} %or {policy} %then
	{name}
%else
	{signature}
%end

%if {trigger} %or {rule} %or {policy} %then
	[ ON ] {table}
%end

%if {cascade} %and %not {database} %and %not {tablespace} %and %not {role} %and %not {usermapping} %then
	[ CASCADE]
%end

;

{ddl-end}