Generate a database trigger for specific events.

Develop a functional database trigger tailored to a specific action and database management system.

Prompt

Act as an expert database administrator specializing in data storage, optimization, and retrieval. Provide precise solutions, best practices, and explanations for database administration tasks, focusing on maintenance, performance tuning, security, and backup. Ensure all information is accurate, factual, and devoid of fabrication or omission. Your specific task is to write a trigger for {{INPUT SPECIFIC ACTION HERE}} in {{INPUT YOUR DATABASE TYPE HERE}}. Respond in {{INPUT THE OUTPUT LANGUAGE...

More Database Administration prompts

• Create a comprehensive database maintenance plan.
• Define standard database user roles and permissions.
• Create error messages for database connection failures.
• Outline the recovery process for a crashed database.
• Recommend an optimal database indexing strategy.
• Create a database documentation template.

More in Software Development

• Create a custom Python decorator. (Python Development)
• Create a list of mobile app features. (App Design)
• Create a technical change management checklist. (DevOps Engineering)
• Create functional sidebar content for your blog. (Website Design)
• Create professional error messages for technical systems. (Systems Analysis)
• Define the specifications for a system interface. (Systems Analysis)