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

773 reads

Blogs

Containers: Create a Custom Container

By

Creating a custom container is where things get truly exciting. There’s actually a ton...

Mini-Rant: Spoofed Phone Numbers and Trust

By

I’ve seen this more and more over the last year: I receive a phone...

Speaking at SQL Saturday Dallas

By

Speaking at SQLSaturday Dallas! I’m proud to announce that I will be speaking at SQL...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

SQL Server health check

By 892717952

If I want to do a SQL Server health check, which aspects should be...

CPU?Memory and IO bottleneck check

By 892717952

Which indices will show  cpu bottleneck?memory bottleneck and IO bottleneck? for example: which indices...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers