How to Quickly List Table Column Names in Any SQL Server Database

Описание: If you find this SQL tutorial useful please LIKE and SUBSCRIBE!

In this video I show three techniques of querying a SQL Server database and returning a list of column names from any database table.

00:00 - Introduction
00:14 - Querying sp_columns
01:12 - Querying sys.columns
03:27 - Querying INFORMATION_SCHEMA

The first technique is to make use of the system stored procedure sp_columns. The second method is to query the tables sys.tables and sys.columns. The third method queries the INFORMATION_SCHEMA.COLUMNS view.

If you get any errors while using these techniques, or they don't return the data you're expecting then check your SQL user privileges.

Just bear in mind that these techniques may return slightly different results sets depending on what database version you're using. The full documentation for the methods used in this tutorial are available here:

sp_columns reference: https://docs.microsoft.com/en-us/sql/...
sys.columns reference: https://docs.microsoft.com/en-us/sql/...
sys.all_columns reference: https://docs.microsoft.com/en-us/sql/...
INFORMATION_SCHEMA.COLUMNS reference: https://docs.microsoft.com/en-us/sql/...

You might also want to check my video about how to return a list of tables from any SQL Server database:    • How to Quickly List Table Names in Any SQL...