---
title: "What is the SQL command to find all triggers from database?"  
description: "What is the SQL command to find all triggers from database?"  
author: "Ashutosh Kumar Verma"  
published: 2021-11-09  
canonical: https://www.mindstick.com/interview/33807/what-is-the-sql-command-to-find-all-triggers-from-database  
category: "mssql server"  
tags: ["sql server", "sql"]  
reading_time: 1 minute  

---

# What is the SQL command to find all triggers from database?

Write a SQL command to find all triggers from database.

## Answers

### Answer by Steilla Mitchel

## SQL command to find all Triggers from database:

The following SQL command is used to find all the Triggers of current active database in SQL Server.

```
select * from sys.objects where type='tr';
```

![What is the SQL command to find all triggers from database?](https://www.mindstick.com/interviewquestion/409f1e23-646f-49f5-a165-04f96da2460d/images/e0fa545f-4e78-43da-bb29-6cd43ba68037.png)

### Answer by Ashutosh Kumar Verma

Write a SQL command to find all triggers from database.


---

Original Source: https://www.mindstick.com/interview/33807/what-is-the-sql-command-to-find-all-triggers-from-database

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.