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,502 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

775 reads

Blogs

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

I’m Speaking at #SQLSatSpokane

By

I am super excited to announce that I have been selected to speak at...

Common commands and tasks to make dealing with Windows Core easier.

By

I don’t know how many of you are working with Windows Core these days...

Read the latest Blogs

Forums

Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 2

By Ginger Keys Daniel

Comments posted to this topic are about the item Move Data from SQL Server...

Knowing What You Don’t Know

By Grant Fritchey

Comments posted to this topic are about the item Knowing What You Don’t Know

Automate Import of LIBOR Rates

By Phil Parkin

Does anyone have any recommendations for sites which publish the daily LIBOR rates in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers