A DDL operation that quickly removes all rows.

learn more… | top users | synonyms

1
vote
1answer
16 views

Deleting data from some but not all tables

I've got a moderately large sql server db for which some data is imported from an external system, and some is entered through the front end or set up when the app is set up. I want to delete all the ...
0
votes
1answer
65 views

I have run truncate table but it is still showing table occupying space?

I have run truncate table but the Heidi SQL is still showing table occupying space. Database: MYSQL 5.6.26 I have truncated the con_consumer table but heidi is still showing it taking space. Even ...
3
votes
0answers
77 views

LOG BACKUP is TRUNCATING in Log Shipping

I had configured Log shipping from INSTANCE1 to INSTANCE2. For the past few days, am able to find that the log backup is truncating only at the midnight. Due to this, LSRestore Job in INSTANCE2 got ...
1
vote
0answers
66 views

Prevent truncate without denying ALTER permission

Is there a way to disallow users from truncating a table without denying ALTER permission on the table? Users should be able to maintain the standard ALTER permissions (adding columns to a table, etc.)...
0
votes
0answers
556 views

Alternatives for UPDATE statement Oracle 11g

I'm currently using Oracle 11g and let's say I have a table with the following columns (more or less) Table1 ID varchar(64) Status int(1) Transaction_date date tons of other columns And this ...