[ADD] add view for mssql api