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, 1859🔥, 0💬
Popular Posts:
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...