search

martinjw / dbschemareader

Read database metadata (from SqlServer/Oracle/MySql/SQLite/PostgreSql/DB2 etc) into one simple model
Microsoft Public License
293 stars 128 forks source link

SQL Server: Retrieves SQL for inline table-values functions. #96

Closed bernarden closed 5 years ago

bernarden commented 5 years ago

SQL Server change: Adds 'IF' sys.object type for retrieving and mapping SQL.

Note: I did notice that the 'PC' type was also retrieved from DB but not mapped to stored procedures. Let me know if you want that extra case on line 65 or whether the 'PC' type should be removed from DB query.

martinjw commented 5 years ago

Thanks! We don't don't distinguish the CLR procedures, but I guess it's worth including them in the procedures list.