This first query will return all of the tables in the database you are querying.
SELECT
*
FROM
INFORMATION_SCHEMA.TABLES
where table_name like '%tablename%'
The second query will return a list of all the columns and tables in the database you are querying.
SELECT
TABLE_NAME,
COLUMN_NAME
FROM
INFORMATION_SCHEMA.COLUMNS
Or, you can also query for just the COLUMNS
from a specific table and return the column names from the specific table ‘Album’ in our database.
SELECT
COLUMN_NAME
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'Album'
No comments:
Post a Comment