Menu
From the MySQL console, what command displays the schema of any given table?
246
For a list of tables in the current schema, use the Show Tables command. For a list of views in the current schema, use the Show Views command. For a list of available schemas, use the Show Schemas command. If the table or view is in a particular schema, qualify it with the schema name.
You can get a list of the schemas using an SSMS or T-SQL query. To do this in SSMS, you would connect to the SQL instance, expand the SQL database and view the schemas under the security folder. Alternatively, you could use the sys. schemas to get a list of database schemas and their respective owners.
After logging into the MySQL command line client and selecting a database, you can list all the tables in the selected database with the following command: mysql> show tables; (mysql> is the command prompt, and "show tables;" is the actual query in the above example).
For formatted output:
describe [db_name.]table_name; For an SQL statement that can be used to create a table:
show create table [db_name.]table_name; 
SHOW CREATE TABLE yourTable; or
SHOW COLUMNS FROM yourTable; If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
