🔒 Locked

MySQL internal command

Started by wah_on_2 Dec 20, 2002 at 9:51 AM 2 replies 200+ views

Original Post

Dec 20, 2002 at 9:51 AM

Hihi, i am a beginner of MySQL. I want to know how can i get the table names using the MySQL internal command for a sql query? e.g. Oracle SELECT table_name from user_table; e.g. SQL_SERVER select name from sysobjects where type = ''U''; I can''t frind this information from the documents of the MySQL. Pls help. Thanks a lot of.

George2

Dec 20, 2002 at 12:21 PM

show tables;

wah_on_2

Author

wah_on_2

Dec 21, 2002 at 12:01 AM

yes. The documents also mentioned that use show tables;

However, if i want to filter some of the tables, e.g. i just want to show the user tables, all system tables are filtered. How can i set the criteria?

Dean Harding

Dec 21, 2002 at 12:11 AM

You don''t. MySQL doesn''t expose it''s data dictionary to the "outside world" like Oracle and SQL Server...

If I had my way, I''d have all of you shot!

codeka.com - Just click it.

Topic Locked

This topic has been locked by a moderator. New replies are not allowed.