How to get the definition of a trigger back?
Answer / Akanksha Saxena
To get the definition of a trigger in MS SQL Server, you can use the `SELECT` statement with the `sys.triggers` system catalog view. Here's an example: `SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID('your_trigger_name')`
| Is This Answer Correct ? | 0 Yes | 0 No |
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.
What are the different authentication modes in sql server?
What is enhanced database mirroring in sql server 2008?
What is the maximun sixes of .mdf in sql server 2005
What is row_number()?
What is named calculation? : sql server analysis services, ssas
What is sql server management studio? : sql server management studio
What is conditional split?
What is store procedure? How do they work?
Why do we backup Active Directory ?
When we can say that is in BCNF?
Give an example of why you would want to denormalize a database
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)