SQL Columns Metainfo With References

• Tweet
• 

        CREATE VIEW dbo.vw_XL_TableColumnDetails  
AS  
SELECT     tCols.TableName, tCols.ColumnName, tCols.TypeName, tCols.MaxLength, tCols.precision, tCols.scale, tCols.IsPrimaryKey, tCols.IsNullable, tCols.IsIdentity,   
                      tCols.IsComputed, tCols.ColumnOrder, tRef.SourceTable, tRef.SourceColumn  
FROM         dbo.vw_XL_TableColumns AS tCols LEFT OUTER JOIN  
                      dbo.vw_XL_TableReferences AS tRef ON tCols.TableName = tRef.TargetTable AND tCols.ColumnName = tRef.TargetColumn      

Tags:
• SQL sql Metaquery