Repository: incubator-hawq-docs Updated Branches: refs/heads/develop ae597e392 -> 59e6e0548
HAWQ-1218 - add drop language sql reference page (closes https://github.com/apache/incubator-hawq-docs/pull/75) Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/commit/59e6e054 Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/tree/59e6e054 Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/diff/59e6e054 Branch: refs/heads/develop Commit: 59e6e054892ea5ec7e14bb921b45f431816f8924 Parents: ae597e3 Author: Lisa Owen <[email protected]> Authored: Thu Dec 15 10:11:36 2016 -0800 Committer: David Yozie <[email protected]> Committed: Thu Dec 15 10:11:36 2016 -0800 ---------------------------------------------------------------------- reference/sql/CREATE-LANGUAGE.html.md.erb | 2 +- reference/sql/DROP-LANGUAGE.html.md.erb | 49 ++++++++++++++++++++++++++ 2 files changed, 50 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/59e6e054/reference/sql/CREATE-LANGUAGE.html.md.erb ---------------------------------------------------------------------- diff --git a/reference/sql/CREATE-LANGUAGE.html.md.erb b/reference/sql/CREATE-LANGUAGE.html.md.erb index 5a402de..6643fef 100644 --- a/reference/sql/CREATE-LANGUAGE.html.md.erb +++ b/reference/sql/CREATE-LANGUAGE.html.md.erb @@ -90,4 +90,4 @@ CREATE LANGUAGE plsample ## <a id="topic1__section8"></a>See Also -[CREATE FUNCTION](CREATE-FUNCTION.html) +[CREATE FUNCTION](CREATE-FUNCTION.html), [DROP LANGUAGE](DROP-LANGUAGE.html) http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/59e6e054/reference/sql/DROP-LANGUAGE.html.md.erb ---------------------------------------------------------------------- diff --git a/reference/sql/DROP-LANGUAGE.html.md.erb b/reference/sql/DROP-LANGUAGE.html.md.erb new file mode 100644 index 0000000..efb95f8 --- /dev/null +++ b/reference/sql/DROP-LANGUAGE.html.md.erb @@ -0,0 +1,49 @@ +--- +title: DROP LANGUAGE +--- + +Removes a procedural language. + +## <a id="topic1__section2"></a>Synopsis + +``` pre +DROP [PROCEDURAL] LANGUAGE [IF EXISTS] <name> [CASCADE | RESTRICT] +``` + +## <a id="topic1__section3"></a>Description + +`DROP LANGUAGE` will remove the definition of the previously registered procedural language \<name\>. You must have superuser privileges to drop a language. + + +## <a id="topic1__section4"></a>Parameters + +<dt>PROCEDURAL </dt> +<dd>(Optional, no effect) Indicates that this is a procedural language.</dd> + +<dt>IF EXISTS </dt> +<dd>Do not throw an error if the language does not exist. A notice message is issued in this circumstance.</dd> + +<dt> \<name\> </dt> +<dd>The name of an existing procedural language. The name may be enclosed by single quotes.</dd> + +<dt>CASCADE </dt> +<dd>Automatically drop objects that depend on the language (for example, functions written in that language).</dd> + +<dt>RESTRICT</dt> +<dd>Refuse to drop the language if any objects depend on it. This is the default behavior.</dd> + +## <a id="topic1__section6"></a>Examples + +Remove the procedural language `plsample`: + +``` pre +DROP LANGUAGE plsample; +``` + +## <a id="topic1__section7"></a>Compatibility + +`DROP LANGUAGE` is a HAWQ extension; there is no `DROP LANGUAGE` statement in the SQL standard. + +## <a id="topic1__section8"></a>See Also + +[CREATE LANGUAGE](CREATE-LANGUAGE.html)
