sql-server-2005 - 如何在SQL Server 2005中查找 View 的派生列类型？

Question

例如，假设我有一个观点:

CREATE VIEW [dbo].[PaymentSchedule_vw]
AS
    SELECT
         [Order].Id                [Order Id]
        ,[PaymentSchedule].Date    [Payment Date]
    FROM
        _Order123 [Order]
        INNER JOIN
            _Order123_Shedule [PaymentSchedule]
            ON
            [Order].Id = [PaymentSchedule].OrderId

GO

如何发现 [Order Id]和 [Payment Date]的类型？

Answer 1

SELECT c.name,
       t.name,
       c.max_length,
       c.precision,
       c.scale
FROM   sys.columns c
       JOIN sys.types t
         ON t.user_type_id = c.user_type_id
            AND t.system_type_id = c.system_type_id
WHERE  object_id = OBJECT_ID('PaymentSchedule_vw')  

或者，您可以使用 SQL_VARIANT_PROPERTY- some examples here。