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 […]

4.67 (3)

2002-04-17

1,509 reads

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

4.5 (2)

2002-04-16

778 reads

Blogs

SQL Server on Kubernetes Book Published!

By

I’m super proud to announce that Ben E. Weissman and I have published SQL...

Gathering More Digital Data with Tile Slim

By

After my wallet misadventures, I ordered a Tile Slim to track my wallet. It...

Accessibility is not just about slides

By

Although I don’t write about it much on this website, I am on the...

Read the latest Blogs

Forums

subreport blank lines

By ibax

blank line in subreport

Enabling indexes

By SQLHeap

If I disable an index for a large insert/update/delete, what happens when it's enabled...

Database Triggers

By mballentine

Hi, I need to send out an email every time an alarm level is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers