Is there any possibility to create unique column constraint using DDLUtils ? I have not found it in API. Is there other solution then altering table (add unique) just a second after its creation on my own ? ...
I have a list table with 5 entries in it, the first column in the identity column (PK), within a parent table is a column that is related to this list table by ID (FK). I am using C# in a web app to run an ExecuteScalar with a stored procedure to insert the items into the parent table. This is within a SQL database LIST TABLE: ID INT ...
My question is sort of similar to this one I want to check if a DELETE query will fail because of a constraint violation. I'd like to do this on database level because I think letting it fail and catching the error is ugly. Another option is "manually" checking for it using SELECT queries to see if there are constraints, but this is ra...