Hello, I am trying to write a db creation script that will create a database as a well as repair an existing database. What I can't seem to find is a set of key words that will allow me to detect if a column or index already exists in a table and thus skip the creation of the column or index. I've found the proper syntax to check for table existance, but I can't find the syntax for column/index existance.
If someone could point me to a set of docs or an example SQL command, that would be great. I'm using 4.1.1-alpha. Thanks much Shishir Ghate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]