Collections:
"sp_columns" - Getting a List of Columns in a Table in SQL Server
How To Get a List of Columns using the "sp_columns" Stored Procedure in SQL Server?
✍: FYIcenter.com
If you have an existing table, but you don't remember what are the columns defined in the table, you can use the "sp_columns" stored procedure to get a list of all columns of the specified table. The following tutorial script shows you a good example:
sp_columns tip GO TABLE_OWNER TABLE_NAME COLUMN_TABLE TYPE_NAME ... dbo tip id int ... dbo tip subject varchar ... dbo tip description varchar ... dbo tip create_date datetime ...
The "sp_columns" stored procedure returns a long list of properties for each column of the specified table. Take a look at each of them.
2016-11-17, 670👍, 0💬
Popular Posts:
How To Create a Stored Function in Oracle? A stored function is a function with a specified name and...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...