Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sinjin
Starting Member
3 Posts |
 Posted - 2009-02-14 : 18:58:58
|
| Hey everyone!I'm new to SQL and new to this forum. I have a question regarding PgAdmin. I'm attempting to write a trigger and not having much success. Here is what I would like the trigger to accomplish:When a user deletes a supplier from the supplier table I would like to remove (make null) the suppliers number (called inv_man) in the inventory table. Any suggestions or help is greatly appreciated. Hopefully some day I will have enough knowledge to assist someone else.Thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sinjin
Starting Member
3 Posts |
Posted - 2009-02-14 : 19:54:57
|
| pgAdmin is a graphical Open Source management, development and administration tool for PostgreSQL |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sinjin
Starting Member
3 Posts |
Posted - 2009-02-15 : 09:41:17
|
| ok, sorry about that. Out of curiousity how would you write such a code in Microsoft SQL? That way when I can see the differences and maybe learn more about both.Thanks |
|
|
|
|
|
|
PgAdmin III