Monday, May 20, 2013

SQL Query to List All Columns alphabetically


select c.name from
    sys.columns c
    join sys.tables t on c.object_id = t.object_id
where t.name = 'Article'
Order by
    c.name