DROP TABLE(7) PostgreSQL 9.2.7 Documentation DROP TABLE(7)NAME
DROP_TABLE - remove a table
SYNOPSIS
DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP TABLE removes tables from the database. Only the table owner, the schema owner, and superuser can drop a table. To empty a table of
rows without destroying the table, use DELETE(7) or TRUNCATE(7).
DROP TABLE always removes any indexes, rules, triggers, and constraints that exist for the target table. However, to drop a table that is
referenced by a view or a foreign-key constraint of another table, CASCADE must be specified. (CASCADE will remove a dependent view
entirely, but in the foreign-key case it will only remove the foreign-key constraint, not the other table entirely.)
PARAMETERS
IF EXISTS
Do not throw an error if the table does not exist. A notice is issued in this case.
name
The name (optionally schema-qualified) of the table to drop.
CASCADE
Automatically drop objects that depend on the table (such as views).
RESTRICT
Refuse to drop the table if any objects depend on it. This is the default.
EXAMPLES
To destroy two tables, films and distributors:
DROP TABLE films, distributors;
COMPATIBILITY
This command conforms to the SQL standard, except that the standard only allows one table to be dropped per command, and apart from the IF
EXISTS option, which is a PostgreSQL extension.
SEE ALSO
ALTER TABLE (ALTER_TABLE(7)), CREATE TABLE (CREATE_TABLE(7))
PostgreSQL 9.2.7 2014-02-17 DROP TABLE(7)
Check Out this Related Man Page
DROP FOREIGN TABLE(7) PostgreSQL 9.2.7 Documentation DROP FOREIGN TABLE(7)NAME
DROP_FOREIGN_TABLE - remove a foreign table
SYNOPSIS
DROP FOREIGN TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP FOREIGN TABLE removes a foreign table. Only the owner of a foreign table can remove it.
PARAMETERS
IF EXISTS
Do not throw an error if the foreign table does not exist. A notice is issued in this case.
name
The name (optionally schema-qualified) of the foreign table to drop.
CASCADE
Automatically drop objects that depend on the foreign table (such as views).
RESTRICT
Refuse to drop the foreign table if any objects depend on it. This is the default.
EXAMPLES
To destroy two foreign tables, films and distributors:
DROP FOREIGN TABLE films, distributors;
COMPATIBILITY
This command conforms to the ISO/IEC 9075-9 (SQL/MED), except that the standard only allows one foreign table to be dropped per command,
and apart from the IF EXISTS option, which is a PostgreSQL extension.
SEE ALSO
ALTER FOREIGN TABLE (ALTER_FOREIGN_TABLE(7)), CREATE FOREIGN TABLE (CREATE_FOREIGN_TABLE(7))
PostgreSQL 9.2.7 2014-02-17 DROP FOREIGN TABLE(7)
hi
i am facing a problem when i run a shell script to load a table.the error is
Record 1: Rejected - Error on table TRENDS."SHP_CUST_ORD_ITM".
ORA-14400: inserted partition key is beyond highest legal partition key
Record 2: Rejected - Error on table TRENDS."SHP_CUST_ORD_ITM", column... (4 Replies)
MSG="THERE WERE XX RECORDS IN ERROR TABLE,AAAA, WHEN LOADING THE BBBB TABLE WITH EXTRACT FROM CCCC INTO TABLES FOR , DATABASE DDDD."
echo "$MSG" > /tmp/mplanmsg.$$.out
I wan to replace XX with the content in $recordXX
cat /tmp/mplanmsg.$$.out|sed 's/XX/\$recordXX/g'| sed... (3 Replies)
I use the following command to know the create table structure.
mysqldump myDBName myTBName -d --compact
And I get the following output...
CREATE TABLE `tblThreads` (
`threadID` smallint(4) unsigned zerofill NOT NULL auto_increment,
`threadTitle` varchar(255) NOT NULL default '',... (7 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
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)
Hi
I get some differents output from a bash script.
My goal is to sort them in a kind of table, something like:
Actually the table can change and I don't care about the shape, I'm just looking if there's a well know way to put the output of a script in a table or if someone has his own best... (2 Replies)
Hi,
I need to extract the table name from an oracle control file which comes as the last word in the third line.
Ex:
LOAD DATA
INFILE '/home/user/files/scott.dat'
INTO TABLE SCOTT.EMP_SAL
FIELDS TERMINATED BY..........
what i want to to is write the table name SCOTT.EMP_SAL to a... (2 Replies)
Hello All,
My file content is:
DROP TABLE
"FACT_WORLD";
CREATE TABLE "FACT_WORLD" (
"AR_ID" INTEGER NOT NULL,
"ORG_ID" INTEGER NOT NULL
)
DATA CAPTURE NONE
COMPRESS YES;
I want to change this file to have entries in one... (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)
Data_Consolidation_Engine_Part_2_Job2..TgtArBkt: ORA-00942: table or view does not exist
I have some thing like above in the file..
Upto this portion Data_Consolidation_Engine_Part_2_Job2..TgtArBkt: the length can be vary ..
Can some one help me in taking this portion alone ORA-00942:... (7 Replies)
I want to check for rows in a table where all values (except the key) is empty. I am using MySQL 5.5.
I plan to do this mechanically, so the approach should work for any table in my database schema.
Suppose for illustration purposes I start with the following table:
CREATE TABLE `sources` (
... (4 Replies)
I want to truncate a table using sqlplus where the table name is in shell variable:
I am using :
sqlplus -s / <<end
truncate table $TABLE
end (2 Replies)
Hi,
I want to retrieve the base table name for a table and replace the table with the view name in the file.
I was trying to retrieve the base with the below db2 command but i am getting "1" as return value.
Could you anyone please assist ?
Table_name=system("db2 -x... (4 Replies)
Hi I have a file where i want to remove a char before a specific pattern.
exp:
CREATE TABLE
(
A,
B,
C, ----comma needs to be removed
)AS SELECT
A,
B,
C, ----comma needs to be removed
FROM TABLE.
So i want to delete the comma(,) after the C both ways.Pattern can be... (11 Replies)
Hi All,
As per my biz requirement, I need to drop the partition from our PROD table based on the retention period.
Hence I have written the script and called the drop partition procedure within the script.
The procedure is working fine and droped the partition from the table when I execute... (4 Replies)