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