Liquid Fire Posted March 18, 2008 Share Posted March 18, 2008 is SHOW TABLES and SHOW TABLES LIKE '%table%' valid is all major db software like mysql, pssql, mssql, db2, etc... Quote Link to comment Share on other sites More sharing options...
Barand Posted March 18, 2008 Share Posted March 18, 2008 AFAIK it's MySQL only Quote Link to comment Share on other sites More sharing options...
fenway Posted March 18, 2008 Share Posted March 18, 2008 I believe that INFORMATION_SCHEMA is part of the SQL standard.... MySQL 5+ only. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.