Get all information schema from Database tables

MasthanMasthan
in MySQL

Information schema views provide an internal,

system table-independent view of the SQL Server metadata.

Examples:

select * from INFORMATION_SCHEMAcolumns as table1 INNER JOIN INFORMATION_SCHEMA.tavble2

ON table1.TABLE_SCHEMA = table1 AND table2.TABLE_NEME =table1.TABLE_NAEM

WHERE table1.TABLE_TYPE ='base table'.

Sign In or Register to comment.