Page 1 of 1

checking to see if tables exists?

Posted: Tue Jun 14, 2011 6:28 am
by kcwvc52
this may be a stupid question but this is all very new to me. lets say i have a button that creates a table named users. and lets say i stored some data into that table. if i hit the button again will it recreate the table and trash the data i had in my table or will it check to see if the table exist and do nothing. if it does trash it how can i go about checking to see if the table exists.

Re: checking to see if tables exists?

Posted: Tue Jun 14, 2011 12:01 pm
by Klaus
Hi kcwvc52,

this finction return the name of all table in a given database: revDatabaseTableNames(databaseID)
So you can then check if "users" is in this list.


Best

Klaus