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

"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, 670👍, 0💬

💬 2018-03-29 Eric: That works. Thanks!

"sys.columns" - Getting a List of Columns in a Table in SQL Server
How To Get a List of Columns using the "sys.columns" View in SQL Server? If you have an existing table, but you don't remember what are the columns defined in the table, you can use the "sys.columns" system view to get a list of all columns of all tables in the current database. In order to a list o... 2016-11-17, 1050👍, 0💬

Generating CREATE TABLE Script on Existing Tables in SQL Server
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an existing table was created, you can use SQL Server Management Studio to automatically generate a "CREATE TABLE" script The following tutorial shows you how to do this: 1. Run SQL Server Management Stud... 2016-11-17, 776👍, 0💬

"sp_help" - Getting a List of Columns in a Table in SQL Server
How To Get a List of Columns using the "sp_help" Stored Procedure in SQL Server? Another way to get a list of columns from a table is to use the "sp_help" stored procedure. "sp_help" returns more than just a list of columns. It returns: the table information, the column information, the identity col... 2016-11-17, 714👍, 0💬

"sp_columns" - Getting a List of Columns in a Table in SQL Server
How To Get a List of Columns using the "sp_columns" Stored Procedure in SQL Server? 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 tutori... 2016-11-17, 671👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.