DROP LANGUAGE(7) SQL Commands DROP LANGUAGE(7)NAME
DROP LANGUAGE - remove a procedural language
SYNOPSIS
DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ]
DESCRIPTION
DROP LANGUAGE removes the definition of a previously registered procedural language. You must be a superuser or the owner of the language
to use DROP LANGUAGE.
PARAMETERS
IF EXISTS
Do not throw an error if the language does not exist. A notice is issued in this case.
name The name of an existing procedural language. For backward compatibility, the name can be enclosed by single quotes.
CASCADE
Automatically drop objects that depend on the language (such as functions in the language).
RESTRICT
Refuse to drop the language if any objects depend on it. This is the default.
EXAMPLES
This command removes the procedural language plsample:
DROP LANGUAGE plsample;
COMPATIBILITY
There is no DROP LANGUAGE statement in the SQL standard.
SEE ALSO
ALTER LANGUAGE [alter_language(7)], CREATE LANGUAGE [create_language(7)], droplang(1)SQL - Language Statements 2010-05-14 DROP LANGUAGE(7)
Check Out this Related Man Page
DROP SCHEMA(7) SQL Commands DROP SCHEMA(7)NAME
DROP SCHEMA - remove a schema
SYNOPSIS
DROP SCHEMA [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP SCHEMA removes schemas from the database.
A schema can only be dropped by its owner or a superuser. Note that the owner can drop the schema (and thereby all contained objects) even
if he does not own some of the objects within the schema.
PARAMETERS
IF EXISTS
Do not throw an error if the schema does not exist. A notice is issued in this case.
name The name of a schema.
CASCADE
Automatically drop objects (tables, functions, etc.) that are contained in the schema.
RESTRICT
Refuse to drop the schema if it contains any objects. This is the default.
EXAMPLES
To remove schema mystuff from the database, along with everything it contains:
DROP SCHEMA mystuff CASCADE;
COMPATIBILITY
DROP SCHEMA is fully conforming with the SQL standard, except that the standard only allows one schema to be dropped per command, and apart
from the IF EXISTS option, which is a PostgreSQL extension.
SEE ALSO
ALTER SCHEMA [alter_schema(7)], CREATE SCHEMA [create_schema(7)]
SQL - Language Statements 2010-05-14 DROP SCHEMA(7)
I entered the command cat 401328 in an attempt to see a file. Now, my screen is displaying machine language. The properties of the file say that it is a postgres application. Is there a command I can enter so everything gets back to normal?
Thanks, (2 Replies)
Here I want to calculate mean,variance and sum from a file
1.1*2*4*22*211*22*12*22*22*11
2.2*2*22*12*22*11*11*122*33*22
3.9*7*22*88*87*98*67*66*56*66*11
As this is a large file and i am trying to write in c
where formulae of
MEAN = 1/N (X1...+..Xn)
Variance = square root of 1/N-1... (9 Replies)
Hello,
I'm wondering what methods and tools are used to describe procedural programs? Is UML suitable for such tasks? I've studied SDL in the university - we used it for specification of telecommunication services. Is it suitable for general description of procedural programs?
If not what... (2 Replies)
I'd like to write a program (I'm flexible on language; C/C++ was my original idea but a scripting language would probably be better) that runs hundreds of programs, but only N = 4 (say) at a time. The idea is to keep all the cores on a multicore machine busy.
How can I do this? In particular,... (6 Replies)
Hi
Please help me to resolve the below query.
My shell script has generated a file output.file like below
********************************
DROP TABLE GPS_CONTACT_DETAILS
DB20000I The SQL command completed successfully.
CREATE TABLE GPS_CONTACT_DETAILS ( CONTACT_ID ... (8 Replies)
I need a small and simple clarification...
Can someone tell me whether PERL is a programming language or not.
Also, can shell scripts also considered as programming language or not.
Also, please tell me the exact difference between programming language and scripting.
Please help.... (3 Replies)
These days i am learning more about Java language and feel it is an interesting language than others.
Is there some books on it to make this language easy to me? (2 Replies)
Hi, I just bought a new mac and have been running a program out of terminal, but even early on I noticed that my single quotes looked a lot different from the ones used in all of the namelists and other files of the program. Specifically, mine are kind of slanted whereas the others are very... (7 Replies)
Shell : bash that comes with RHEL 6.7
I have SQL scripts like below. I want to convert all the text in these files to lower case except the strings enclosed within single quotes .
Any idea how I can achieve this ?
Sample text:
$ cat sample.txt
SELECT ... (6 Replies)
hi,
I want that a language change in windows won't effect Linux language (which should be always English).
I had that feature but A Windows update changed it.
How can I fix it? (7 Replies)
I need to fix an SQL statement in MySQL that should calculate a field using values from two of the columns and I prefer to do this using set-based programming, ie not procedural. What needs to happen is that in a separate column called "delta" the value of "level" is copied depending on whether... (3 Replies)