We can add and delete indexes through the UI or with SQL code In MySQL, the primary key and foreign key we create on a table is always an index automatically.

I've got an interesting constraint I'm trying to add to our database. I can do with with triggers, but am curious if there is a more elegant way to do this in T-SQL (SQL2005, FWIW) We have two related ...

is the name for the constraint being specified. The first form of the CREATE TABLE statement creates tables that automatically map SQL data types to those supported by the SAS System. Use this form ...