Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I count how many records are deleted?

Status
Not open for further replies.
jliang

jliang

MIS
Apr 26, 2004
30
US
Hi,

Does Teradata has function to count how many rows were deleted after I deleted several rows using delete statement?

Thanks very much in advance.

Jing
 
Sort by date Sort by votes


The activity count returned by the delete statement has the row count of how many rows were deleted.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Teamalone
  • Locked
  • Question
How to export multiple files using teradata tpt
Replies
0
Views
179
Teamalone
Teamalone
multipledatabases
  • Locked
  • Question
How to bulk import a CSV or a TXT file trough command into a Teradata database
Replies
1
Views
293
Miguel93
Miguel93
btrini
  • Locked
  • Question
Fastload logon shows as invalid but I can log on to Teradata SQL Assistant with the same credentials
Replies
1
Views
124
SamBones
SamBones
jholl
  • Locked
  • Question
Create Volatile Table in Teradata is showing 0 rows being processed
Replies
0
Views
135
jholl
jholl
nikhitha23
  • Locked
  • Question
How to automate a teradata script in UNIX
Replies
0
Views
52
nikhitha23
nikhitha23

Part and Inventory Search

Sponsor

Back
Top