Re: Constraint checking

2006-03-21 Thread Martijn Tonies
Hello Barbara, > When does constraint checking occur? > > I can create a table that has a constraint on a column that doesn't exist. I would expect an error on the table creation, but the table gets created successfully. > > I'm running on windows 5.0.18 client/serve

Constraint checking

2006-03-21 Thread Barbara Deaton
When does constraint checking occur? I can create a table that has a constraint on a column that doesn't exist. I would expect an error on the table creation, but the table gets created successfully. I'm running on windows 5.0.18 client/server. mysql> show create