MS SQL Server Concepts and Programming Question:
Download Job Interview Questions and Answers PDF
How To Get a List of Columns using the "sp_help" Stored Procedure in MS SQL Server?
Answer:
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
Download MS SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How To Get a List of Table Columns using the "sp_columns" Stored Procedure in MS SQL Server? | How To Generate CREATE TABLE Script on an Existing Table in MS SQL Server? |