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:
2016-11-17, 727👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
What Is SQL in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Rela...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...