Skip to content
Advertisement

How to Pick Column names from table

I have tables which have columns and tables

I have INFORMATION_SCHEMA.COLUMNS to get Table names

Script :

I have got table names

Here I got table names

Output :

I need to get output which table have which column

Advertisement

Answer

I believe you want to connect table name and column name from @tbl_column. If yes I think you can use following script:

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement