is there a way to check the exsistance of a table? I want something similar to this:
SELECT COUNT(*) FROM table1
but for a table (in a given database), not rows within a table
I know of another line command:
check table table1 quick
but this gives back too much information, is there a command which returns only 1 cell of information? If not i guess i can keep usign the previous command
With command "show tables", u get all the names of the tables existent in a database...
Vans
yes but I was hoping for an effecient way to do this! I have almost 300 tables in 1 database so as you can see that really wounldn't be an ideal search method as check table would be much quicker and effecient ... i guess that is what i will have to go with
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.