asked on
ASKER
ASKER
ASKER
Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.
TRUSTED BY
IF (some criteria) THEN
'do this
else
'do that
end if
Instead, use the SQL IF construct (no THEN or END IF required, but good to surround commands with begin..end)
IF EXISTS(SELECT constraint_name FROM information_schema.table_c
begin
ALTER TABLE "ProductPurchased" DROP CONSTRAINT "FK_ProductPurchased_Custo
end