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, 1948🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...