1SELECT
2 table_name,
3 column_name,
4 data_type
5FROM
6 information_schema.columns
7WHERE
8 table_name = 'city';Code language: SQL (Structured Query Language) (sql)
1
2
3
4
5 SELECT
6 table_name,
7 column_name,
8 data_type
9FROM
10 information_schema.columns
11WHERE
12 table_name = 'city';