entity framework - How to get column names from database? -
i'm working entity framework. there method column names of table database?
i want display column names in database.
not directly entity framework, far know - can execute standard t-sql query against catalog views:
select columnname = c.name, schemaname = s.name, tablename = t.name sys.columns c inner join sys.tables t on c.object_id = t.object_id inner join sys.schemas s on t.schema_id = s.schema_id
this give columns, along schema , table they're part of, current sql server database.
Comments
Post a Comment