2 thoughts on “desc is sp_columns in Sql Server”

  1. FYI I’ve been working on a SQL version of DESCRIBE that would include tables, views, stored procedures and table-valued functions. I totally forgot about sp_columns. Not quite the same output (I prefer DESCRIBE) and it does just cover tables and views (which if I’m not mistake DESCRIBE does too).

    Still, thanks for pointing that out – I’ll put my DESCRIBE on a backburner and point this out to Oracle-based SQL Server students when they ask me if there’s an equivalent.

  2. Thanks James.

    Yes, DESCRIBE in Oracle does cover views.

    I like the output of DESCRIBE too. sp_columns gives just a tad too much…

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>