DROP SCHEMA(7) PostgreSQL 9.2.7 Documentation 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))
PostgreSQL 9.2.7 2014-02-17 DROP SCHEMA(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)
Guys,Please look at a simple shell which validates presence of a customer table in OASIS schema. SQL Query for validation is wrong(Table name in quotes should not have schema name OASIS.). And shell is working correctly (with exit 1) as it will never get count=1 with this query.
But it is... (2 Replies)
How can
grep G.*schema
give me the result: ${Gacntg_dt}""'"'
doesn't G.*schema say give me an unlimited number of characters between G and schema?
:confused: (3 Replies)
Daily one file will dropped into this directory.
Directory: /opt/app/jt/drop
File name: XXXX_<timestamp>.dat.gz
I need to write a script which checks whether the file is dropped daily or not.
Any idea in the script how can we compare timestamp of the file to today's date?? (3 Replies)
Hi,
I need my script to accept a column name and give all the tables and its schema.
Any kind of help is appreciated...
Thanks in advance... (2 Replies)
inputfile has 3 columns
SCHEMA.TAB1 COL1 LENGTH
SCHEMA.TAB2 COL2 LENGTH.
If i use awk on the above inputfile
awk '{print $1}' inputfile.The out put will be
SCHEMA.TAB1
SCHEMA.TAB2.
But from the above output i need to delete SCHEMA. i.e i don't want the string "SCHEMA." should... (6 Replies)
what I'm trying to do is ... need to drop tables w/ names like
ABC_NY_2001
ABC_ORD_2001
ABC_TX_2001
ABC_CL_2001
For this, I want to write a query "DROP TABLE ABC_var_2001".
now "var" should be either NY, ORD, TX or CL.
I'm new to programming so don't know how to create a variable w/ OR... (3 Replies)
Hi all,
I'm facing a problem with a query in a shell script (AIX).
sqlplus -s NAME/PASS@SCHEMA<<EOF
set echo off
UPDATE HISTORY SET HISTORY.ID = (SELECT OFFER.ID FROM OFFER WHERE HISTORY.ID=TO_NUMBER(OFFER.CODE)) WHERE EXISTS (SELECT OFFER.ID FROM OFFER WHERE... (5 Replies)
Hi,
I have a file containing the DDLs of tables in a schema. From that I need to remove all the lines from a starting string till a specific string. Here is an example.
File1.txt
-------------
CREATE TABLE "SCHEMA1"."LKP11_TBL_USERS"
( "ID" NUMBER(8,0) NOT NULL ENABLE,
"USER_ID"... (3 Replies)
Hello All,
I hope I'm posting this in the right section.
I have zero sql query writing skill, in fact, I've never done it before, but for some reason, a request came across my desk to get information from one of our databases. I have about 200 ticket numbers that have no information attached,... (8 Replies)
Hello,
I have file (PARFILE) with string on first line:
INCLUDE=SCHEMA:"IN\( 'SCHEMA1','SCHEMA2','SCHEMA3' \)"In .sh script I use:
....
IMPORT_SCHEMA=`awk 'NR==1{print $2}' ${PARFILE}`
...print $2 is because 'SCHEMA1','SCHEMA2','SCHEMA3' is 2nd column in file
echo "$IMPORT_SCHEMA"... (5 Replies)
Hello friends,
There is one requirment where I need to login into database environment and pull all schema names into a text file ...
as of now below are the schemas available...
$> describe keyspaces;
system_schema system_auth system abc system_distributed system_traces
Now from... (4 Replies)
in my shell script requirement is to search and replace the file with variable so i use the following command sed -i "s/abc/$SCHEMA/g" table.sql
later when the script runs sqlplus username/pwd@Table& this & is not letting the variable to replace the value inside the file .please let me know... (1 Reply)