At 14:08 -0500 7/26/04, Ghate, Shishir wrote:
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.
You could use the SHOW COLUMNS and SHOW INDEX statements?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
