Find User who dropped table in teradata DB

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Records not dropped from UNIX Script

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...

2. News, Links, Events and Announcements

MySQL dropped in favor of MariaDB

Fedora and openSUSE will replace MySQL with MariaDB: Oracle who? Fedora & openSUSE will replace MySQL with MariaDB | ZDNet The article also has a comment that Chakra is planning on doing the same. No doubt the Fedora based distributions are planning to do the same.

3. Shell Programming and Scripting

Find highest records in table

Dear All, I have table files with different measurements for the same sensors. The first column indicate the sensor (7 different sensors and 16 measurements in the example below). I would like to find the best measurement for each sensor. The best measurement is determined by the higher value of...

4. Ubuntu

System chrashe , dropped into Busybox

This is the mistake that i've done : First of all go to /etc/apt/sources.list folder from terminal or using file manager ... than copy the content of sources.list in to your adequate source.list. Create a file named sources.list.bt and paste the same content In the end open the...

5. Shell Programming and Scripting

Number of processes per each user in a table

Hello guys, what i want to do is to print a table with two columns (user :: #procs) on the stdout. The first column should show the users and the second one the number of processes the respective user runs. I think I need something like the count() - function in sql, don't i? Shell: Bash ...

6. SuSE

Recover dropped database

I have deleted a database. I restored it again with a backup. Now we lost some data of two days. Is it possible to restore this lost data?

7. UNIX for Dummies Questions & Answers

are dropped packets a sign of network problem?

in a xen environment , i see a lot op dropped packets via netstat -i Is this a sign of network problems, or is it normal to see this kind of numbers? i'm not sure how to interprete the data. is this normal, bad, critical. What are your stats on this? I guess i have a xen issue of some sort,...

LEARN ABOUT LINUX

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)

UNIX for Advanced & Expert Users