Home Forums SQL Server 2008 SQL Server 2008 - General Is their a way to get metadata info about views RE: Is their a way to get metadata info about views

  • October 1, 2014 at 1:48 pm

    #1749521

    Quick thought, on 2012 this will work

    😎

    SELECT * FROM sys.all_sql_modules WHERE object_id = OBJECT_ID('dbo.MYVIEW')

    SELECT * from sys.dm_exec_describe_first_result_set(N'select * from dbo.MYVIEW',NULL,NULL) as x