Get tables and columns from database - SQL Server -


database abc , contains 2 tables table1 , table2.

i have this:

table1

column1 int column2 nvarchar(50) 

table2

column1 int column2 money column3 bit 

use information_schema schema , objects within

information_schema.columns 

which has of metadata need produce output want.


Comments