[SQL] adding not null constraints on columns

Title: Message Is there a way to add not null constraints on a column after the column has been created?  Any help would be appreciated.  Thanks.   The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. W

Re: [SQL] Create function statement with insert statement

Hi Chris, Pleased to (finally) report success. Here are the solutions: INSERT - DROP FUNCTION orderinsert() ; CREATE OR REPLACE FUNCTION orderinsert() RETURNS OPAQUE AS ' BEGIN IF NEW.CUSTOMER_ID ISNULL THEN RAISE EXCEPTION "CUSTOMER_ID cannot be NULL value" ; END IF ; IF

[SQL] unsubscribe

Unsubscribe Susan Evans Haywood County Schools NCWISE Coordinator 216 Charles Street Clyde, NC 28721 828-627-8314 (Phone) 828-627-8277 (Fax) 216 Charles Street Clyde, NC 28721 ---(end of broadcast)--- TIP 6: explain analyze is your friend

[SQL] unsubscribe

unsubscribe -- Susan Evans Haywood County Schools NCWISE Coordinator 216 Charles Street Clyde, NC 28721 828-627-8314 (Phone) 828-627-8277 (Fax) 216 Charles Street Clyde, NC 28721 ---(end of broadcast)--- TIP 3: Have you checked our extensive

[SQL] unsubscribe

unsubscribe -- Susan Evans Haywood County Schools NCWISE Coordinator 216 Charles Street Clyde, NC 28721 828-627-8314 (Phone) 828-627-8277 (Fax) 216 Charles Street Clyde, NC 28721 ---(end of broadcast)--- TIP 9: In versions below 8.0, the