Skip to main content

Get database schema with one query?

Image
By User


Basically I want to get the table names, and the field names for each table from the current database that is connected, nothing else.



Is this possible?



I know that SHOW TABLES FROM my_database gets you the table names, and SHOW COLUMNS FROM my_table will get you the fields, but that's at least [1 x # of tables] queries and I get more information that I want :)


Source: Tips4all, CCNA FINAL EXAM
Labels:

Comments

  1. UserMay 10, 2012 at 3:09 AM

    The INFORMATION_SCHEMA.COLUMNS table has what you're asking for.

    SELECT table_name, column_name
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE table_schema = 'YourDBName'
    ORDER BY table_name, ordinal_position

    ReplyDelete
  2. UserMay 10, 2012 at 3:09 AM

    SELECT *
    FROM information_schema.tables t
    JOIN information_schema.columns c ON t.TABLE_NAME = c.TABLE_NAME
    AND t.TABLE_CATALOG=c.TABLE_CATALOG
    AND t.TABLE_SCHEMA=c.TABLE_SCHEMA


    works for SQLSERVER 2005. The column names might be different for MySQL (I assume that's what you're using), but the concept is the same.

    ReplyDelete

Post a Comment

Popular posts from this blog

Slow Android emulator

By User
I have a 2.67 GHz Celeron processor, 1.21 GB of RAM on a x86 Windows XP Professional machine. My understanding is that the Android emulator should start fairly quickly on such a machine, but for me it does not. I have followed all instructions in setting up the IDE, SDKs, JDKs and such and have had some success in staring the emulator quickly but is very particulary. How can I, if possible, fix this problem?
30 comments
Read more

CCNA 3 Final Exam => latest version

By User
1 . Which security protocol or measure would provide the greatest protection for a wireless LAN? WPA2 cloaking SSIDs shared WEP key MAC address filtering   2 . Refer to the exhibit. All trunk links are operational and all VLANs are allowed on all trunk links. An ARP request is sent by computer 5. Which device or devices will receive this message? only computer 4 computer 3 and RTR-A computer 4 and RTR-A computer 1, computer 2, computer 4, and RTR-A computer 1, computer 2, computer 3, computer 4, and RTR-A all of the computers and the router   3 . Refer to the exhibit. Hosts A and B, connected to hub HB1, attempt to transmit a frame at the same time but a collision occurs. Which hosts will receive the collision jamming signal? only hosts A and B only hosts A, B, and C only hosts A, B, C, and D only hosts A, B, C, and E   4 . Refer to the exhibit. Router RA receives a packet with a source address of 192.168.1.65 and a destination address of 192.168.1.161...
20 comments
Read more