Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

TSQL GET ALL COLUMNS IN TABLE

/*Get all columns from a table (sql server)*/
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'table name';
 
PREVIOUS NEXT
Tagged: #TSQL #GET #ALL #COLUMNS #IN #TABLE
ADD COMMENT
Topic
Name
5+7 =