Viewing post 1 (of 1 total)
MANU (12/20/2008)select st.name,sc.name fromsys.all_columns sc join sys.tables ston st.object_id=sc.object_idorder by st.nameHTH!MJ
MANU (12/20/2008)
sys.all_columns sc join sys.tables st
on st.object_id=sc.object_id
order by st.name
HTH!
MJ
Thanks MJ!
That helped me out, although I'm not the OP.
DJ
December 22, 2008 at 7:41 am
#916139