Hi, I have got a table which is supposed to contain only one
row. It does not have any primary keys defined. So, essentially, when a new insert happens in that table, I
would like it (the insert) to fail if there is already a row existing in that
table. How can I do that? Can I add any constraints? Or do I need
to write a separate trigger for the same? Thanks and regards, Yateen V. Joshi |
- Re: [GENERAL] Single Row Table? Yateen Joshi
- Re: [GENERAL] Single Row Table? Bruno Wolff III
- Re: [GENERAL] Single Row Table? Scott Marlowe
- Re: [GENERAL] Single Row Table? Jeff Eckermann
- Re: [GENERAL] Single Row Table? Mike Nolan
- Re: [GENERAL] Single Row Table? Thomas Kellerer
- Re: [GENERAL] Single Row Table? Mike Nolan
- Re: [GENERAL] Single Row Table? Thomas Kellerer