Answers

Question and Answer:

  Home  MS SQL Server

⟩ How To Get a List of Table Columns using the "sp_columns" Stored Procedure in MS SQL Server?

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.

 185 views

More Questions for you: