Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

view column data type sql

SELECT COLUMN_NAME, DATA_TYPE 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME = 'yourTableName'
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #view #column #data #type #sql
ADD COMMENT
Topic
Name
4+2 =