Technical Article

Truncating and deleting all tables in a database

Sometimes, during test stage, you may need to truncate or delete all your tables in a database, without droping constraints, truncating and recreating constraints (DRI). You can use the TRUNCATE TABLE statement to removes all rows from a table without logging the individual row deletes, but tables referenced by a FOREIGN KEY constraint can not […]

(3)

You rated this post out of 5. Change rating

2002-04-17

1,577 reads

Technical Article

List of triggers in a database

Give the following information, about triggers in the database.Parent_Name      Parent_Type Name                         Type               Insert Update Delete IsFirstInsertTrigger IsFirstUpdateTrigger IsFirstDeleteTrigger IsLastInsertTrigger IsLastUpdateTrigger IsLastDeleteTrigger

(2)

You rated this post out of 5. Change rating

2002-04-16

840 reads

Blogs

PlanTrace Now Supports PostgreSQL

By

PlanTrace Now Supports PostgreSQL The same plan analysis you know from...

A New Word: the Kinder Surprise

By

the kinder surprise – . the point in your early adolescence when you realize...

Crash-Consistent Snapshot Cloning - Hyper-V Edition

By

If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...

Read the latest Blogs

Forums

Cara Aktivasi QLola Token di HP Baru (via WA):

By coombsauto1

Bantuan aktivasi QLola IB Token ke perangkat baru dapat dilakukan melalui layanan WhatsApp resmi,...

BCA KCP Penjernihan Telpon/wa.085373737699

By laquinta

BCA KCP Penjernihan Telpon/wa.085373737699.Jl. Penjernihan I No.23, Bend. Hilir, Kecamatan Tanah Abang, Kota Jakarta...

BCA KCP Duta Mas Fatmawati CSTelpon : 0853-73737551

By vuakietac

CSTelpon : 0853-73737551 Komplek Pertokoan Duta Mas, Jl. RS. Fatmawati Raya No.8 Blok D1...

Visit the forum

Question of the Day

SSoL Support on the OS

On which Linux versions is SQL Server 2025 on Linux supported?

See possible answers