02-24-2013
What is the database(i.e.oracle, db2, etc.)?
Which tables in the database do you want to remove rows for?
What is the structure(i.e. columns, indexes) of these tables?
Which rows do you want to remove?
10 More Discussions You Might Find Interesting
1. UNIX Desktop Questions & Answers
Trying to delete a directory or a file using a pattern-selective deletion (using “*” and “?” ) (4 Replies)
Discussion started by: herberwz
4 Replies
2. UNIX for Dummies Questions & Answers
Hi all
:wall:
Can anyone advise how do I use ls to do a selective amd sorted listing of file that I want to have as below?
Am looking for files that are named as log_<nnnn>.txt, where <nnnn> are numeric, i.e. I want to have a listing sorted from the newest to the oldest of files that... (7 Replies)
Discussion started by: newbie_01
7 Replies
3. Shell Programming and Scripting
I need RegEx to delete text block delimited by "^--" and "^request saved" if the block contained the pattern "FAILED:No air,rail,hotel or car" in the following.
Many thanks in advance!
company_id=9292 queue_id=72 internationalOnly=0
Building XML...
ABC123
Adding passenger first=First ... (1 Reply)
Discussion started by: roshansharma
1 Replies
4. Shell Programming and Scripting
Hi,
This may not be the right forum but i am hoping someone knows an answer to this.
I have to capture rows for a column that was deleted. How can i do that without having to write a select query?
delete from myschema.mytable where currentdatetimestamp > columnDate
this should delete 5... (4 Replies)
Discussion started by: jakSun8
4 Replies
5. UNIX for Dummies Questions & Answers
Hi All.
I didnt know how to put this question as but i want to delete my values following string_X but need to retain the data in it.
I hope the following might help me in conveying my doubt.
My sequence looks like this.
>string_1 CAJW010000001... (3 Replies)
Discussion started by: sonia102
3 Replies
6. UNIX for Dummies Questions & Answers
Hi
I have a table which looks like this
id | name | length | clone | null
1 | string 1 | 12345643 | string 1 | NULL |
2 | string 2 | 2345612 | string 2 | NULL |
3 | string 3 | 3421556 | string 3 | NULL |
4 | string 4 | 1236742 | string 4 | NULL |
5 | string 5 | 2312677 | string 5 | NULL |... (2 Replies)
Discussion started by: rsi.245
2 Replies
7. UNIX for Dummies Questions & Answers
Hi
I have a question on appending and deleting entries in mysql table.
This is my sample table. table name: details
id_name | model | mode | media| first | end | id | level |
+--------------------+-------+---------+-----+-------+-------+--------+--------+
| PSK_30s1207681L002 | -1 | 1... (7 Replies)
Discussion started by: rsi.245
7 Replies
8. UNIX for Dummies Questions & Answers
Hi
My input file looks like this:
>BAHMI01000090.1 Details of the shopping list 9800 item00090, whole set of listed artifacts and objects
>BAHMI01050012.1 Details of the shopping list 9800 item02310, whole set of listed artifacts and objects
>BAHMI01070078.1 Details of the shopping list ... (5 Replies)
Discussion started by: sonia102
5 Replies
9. UNIX and Linux Applications
Hello,
I am trying to remove some rows in a table, which are including a phrase at a defined column but i could not find the unique result for this.
What I wish to do is to remove all lines including http://xx.yy at link column
... (2 Replies)
Discussion started by: baris35
2 Replies
10. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT SUSE
drop_table
DROP
TABLE(7) SQL Commands 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 its owner can drop a table. To empty a table of rows without destroying the table, use
DELETE [delete(7)] or TRUNCATE [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)]
SQL - Language Statements 2010-05-14 DROP TABLE(7)