General MySQL Oracle SQL Server

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

Q

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

✍: FYIcenter.com

A

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 column, the row GUID column, the primary key, indexes, and constraints. It you run "sp_help tip" in SQL Server Management Studio, you will see the result as shown in this picture:

sp_help Stored Procedure
sp_help Stored Procedure

 

⇒ Generating CREATE TABLE Script on Existing Tables in SQL Server

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

⇑ Managing Tables and Columns in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-11-17, 3771🔥, 0💬

General MySQL Oracle SQL Server