Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - Creating a Simple Table to Test Triggers
(Continued from previous topic...)
How To Create a Simple Table to Test Triggers?
If you want to follow other tutorial examples included in this collection,
you need to run this SQL script to create a simple table called fyi_users:
DROP TABLE fyi_users;
CREATE TABLE fyi_users (
id INTEGER IDENTITY NOT NULL,
name VARCHAR(80) NOT NULL,
email VARCHAR(80) NULL,
password VARCHAR(32) NULL
INSERT INTO fyi_users (name) VALUES ('John King');
INSERT INTO fyi_users (name) VALUES ('Nancy Greenberg');
fyi_users is created now with 2 records.
(Continued on next topic...)
- What Are Triggers?
- What Are the Basic Features of a Trigger?
- How To Create a Simple Table to Test Triggers?
- How To Create a DML Trigger using CREATE TRIGGER Statements?
- How To Test a DML Trigger?
- How To List All Triggers in the Database with sys.triggers?
- How To Modify Existing Triggers using "ALTER TRIGGER"?
- How To Delete Existing Triggers using "DROP TRIGGER"?
- How To Get the Definition of a Trigger Back?
- How To Disable Triggers using "DISABLE TRIGGER"?
- How To Create a Trigger for INSERT Only?
- How To See the Event List of an Existing Trigger using sys.trigger_events?
- How To Access the Inserted Record of an Event?
- How To Access the Deleted Record of an Event?
- How To Improve the Trigger to Handle NULL Values?
- What Happens to a Trigger with Multiple Affected Rows?
- How To Override DML Statements with Triggers?
- How To Create a DDL Trigger using "CREATE TRIGGER" Statements?
- Can You Roll Back the DDL Statement in a Trigger?
- Can You Create a Logon Trigger in SQL Server 2005 Express Edition?