Wednesday, October 2, 2019

SQL Server - onennote lbm


Query to view the structure of a View

select v.name, c.name, t.name , c.max_length , c.precision, c.scale from sys.views v, sys.columns c , sys.types t, sys.objects o
where v.object_id = c.object_id
and c.user_type_id = t.user_type_id
and v.object_id = o.object_id
and o.name like 'ChartOfAccounts';

No comments:

Post a Comment