Tag Archive ค้นหา

DECLARE @search NVARCHAR(max) = '%Pitt%';

SELECT
    DB_NAME() AS DatabaseName,
    SCHEMA_NAME(t.schema_id) AS SchemaName,
    t.name AS TableName,
    QUOTENAME(DB_NAME()) + '.' + QUOTENAME(SCHEMA_NAME(t.schema_id)) + '.' + QUOTENAME(t.name) AS FullyQualifiedDomainName,
    CAST(ep.value AS NVARCHAR(MAX)) AS Description
FROM
    sys.tables t
LEFT JOIN
    sys.extended_properties ep
    ON t.object_id = ep.major_id
    AND ep.name = 'MS_Description'
WHERE
    t.name LIKE @search
    OR CAST(ep.value AS NVARCHAR(MAX)) LIKE @search;