Collections:
"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?
✍: FYIcenter.com
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:
⇒ Generating CREATE TABLE Script on Existing Tables in SQL Server
⇐ "sp_columns" - Getting a List of Columns in a Table in SQL Server
2016-11-17, 2491🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...