Situatie
Mai jos este o procedura ce returneaza toate tabelele, de pe o baza de date MSSQL Server, ce au coloane de tip image.
Solutie
create procedure ListTablesWithImageColumns
as
SELECT [Table] = s.[Name] + N’.’ + t.[Name]
FROM [sys].tables t
JOIN [sys].schemas s ON t.[schema_id] = s.[schema_id]
WHERE EXISTS
(
SELECT 1 FROM [sys].columns c
WHERE c.[object_id] = t.[object_id]
AND c.system_type_id = 34
)
Leave A Comment?