This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

A list of one owl's 5 favourite system stored procedures in SQL! Part five of a six-part series of blogs
Everyone has a favourite system stored procedure (you do, don't you?). But five? That's the subject of this blog, anyway. My 5 favourite SQL system stored procedures! Listing the contents of a procedure or function (sp_helptext) Using sp_datatype_info to get the data type of a variable Which tables/procedures depend on which? (sp_depends) Listing the columns in a table (sp_columns) (this blog) Using sp_help to get help on a table, procedure, column, etc

A list of one owl's 5 favourite system stored procedures in SQL!

Part five of a six-part series of blogs

Everyone has a favourite system stored procedure (you do, don't you?). But five? That's the subject of this blog, anyway.

Posted by Andy Brown on 03 February 2017

Listing the columns in a table (sp_columns)

Want to know what's in a table without having to click on it? Here's an example, listing the columns in a table called Director:

-- list out the columns used by this table

sp_columns 'Director'

Here are the first few columns this returns:

The first few columns of information returned.

You can also use sp_tables on its own to list out all of the tables in your database.

Parts of this blog
My 5 favourite SQL system stored procedures! Listing the contents of a procedure or function (sp_helptext) Using sp_datatype_info to get the data type of a variable Which tables/procedures depend on which? (sp_depends) Listing the columns in a table (sp_columns) (this blog) Using sp_help to get help on a table, procedure, column, etc