Start SQL Image Viewer and connect to your database. For SQL Server databases, tables containing blob columns will be highlighted in green in the list of database objects. Write the query to retrieve your images, and execute the query.
SQL Image Viewer will then display the result set, together with any images it finds in the blob column(s).
Note that you did not need to specify the type of image stored in the column. In this example, we only selected the blob column, and SQL Image Viewer was able to automatically determine the image format and also display the image details. If you prefer, you can choose to display only the image details in the data set.
SQL Image Viewer supports the following image formats:•BMP•GIF (Graphic Interchange Format, static and animated)•JPEG•PNG (Portable Network Graphics)•PSD (Photoshop)•TIFF (Tagged Image File Format, single and multi page)•DICOMYour query can be as complex as you need it to be, and can return more than one blob column for each row. E.g.
How to view images stored in your database
Get started with SQL Image ViewerMake working with blobs easier - try SQL Image Viewer free for 14 days
Got a question?If you need help, or have any questions about SQL Image Viewer, please get in firstname.lastname@example.org
•identifies images and file types automatically•identify images and files stored in OLE Object columns•export embedded images to Excel spreadsheets•supports Access, Firebird, MySQL, Oracle, PostgreSQL, SQL Server, SQL Server Compact, SQLite, and ODBC data sources