"sp_columns" - Getting a List of Columns in a Table in SQL Server

Q

How To Get a List of Columns using the "sp_columns" Stored Procedure in SQL Server?

✍: FYIcenter.com

A

If you have an existing table, but you don't remember what are the columns defined in the table, you can use the "sp_columns" stored procedure to get a list of all columns of the specified table. The following tutorial script shows you a good example:

sp_columns tip
GO
TABLE_OWNER TABLE_NAME COLUMN_TABLE TYPE_NAME ...
dbo         tip        id           int       ...
dbo         tip        subject      varchar   ...
dbo         tip        description  varchar   ...
dbo         tip        create_date  datetime  ...

The "sp_columns" stored procedure returns a long list of properties for each column of the specified table. Take a look at each of them.

 

Managing Tables and Columns in SQL Server

⇒⇒SQL Server Database Tutorials

2016-11-17, 485👍, 0💬