Collections:
"sys.columns" - Getting a List of Columns in a Table in SQL Server
How To Get a List of Columns using the "sys.columns" View 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 "sys.columns" system view to get a list of all columns of all tables in the current database.
In order to a list of columns of a single table, you need to join sys.columns and sys.tables as shown in the tutorial example below:
SELECT * FROM sys.columns c, sys.tables t WHERE c.object_id = t.object_id AND t.name = 'tip' GO object_id name column_id user_type_id max_length 2073058421 id 1 56 4 2073058421 subject 2 167 80 2073058421 description 3 167 256 2073058421 create_date 4 61 8
You can see the column names easily from the sys.columns view. But you can only see the column type IDs. This requires another join to get the column type names. You may try the "sp_columns" stored procedure to get a better list of columns shown in the next tutorial.
⇒ "sp_columns" - Getting a List of Columns in a Table in SQL Server
⇐ "sys.tables" - Getting a List of All Tables in SQL Server
2016-11-17, 2120🔥, 0💬
Popular Posts:
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...