Answers for "sql server find all columns with data type"

SQL
2

sql server find columns list in tables

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'DIM_VENDING_MATERIALS'
Posted by: Guest on January-04-2020
1

TSQL GET ALL COLUMNS IN TABLE

/*Get all columns from a table (sql server)*/
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'table name';
Posted by: Guest on June-21-2021

Code answers related to "sql server find all columns with data type"

Code answers related to "SQL"

Browse Popular Code Answers by Language