I have seen multiple questions on how to retrieve every column from every table along with its data type, among many other pieces of information which can be summarised in the shortest way with this query:

```
SELECT * 
FROM INFORMATION_SCHEMA.COLUMNS

```

However, is it possible to get all the data from the columns and ~~the rows they belong to~~ get the first row in the table alongside this? I have not found a way to do so thus far. Is it possible to do such, maybe also having a `WHERE` condition such as checking if the table contains a list of specific columns before returning it e.g.:

```
SELECT <AllTablesAndColumns+FirstRow> 
FROM <WhereTheyCanBeSelectedFrom> 
WHERE <TheTableHasTheseSpecificColumns>

```

Which would return the table name, column name and the data contained within those columns for each row.