Data Type

SELECT TABLE_CATALOG
-- , TABLE_NAME
, COLUMN_NAME, DATA_TYPE
, CHARACTER_MAXIMUM_LENGTH AS TEXT_LENGTH
, NUMERIC_PRECISION
, NUMERIC_SCALE
, COLLATION_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'ชื่อตาราง'

// ตรวจสอบ Primary Key
SELECT COLUMN_NAME, CONSTRAINT_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE TABLE_NAME = 'ชื่อตาราง' 
AND CONSTRAINT_NAME = 'PRIMARY';