mssql query field type Posted in : 電腦相關應用 2017-09-22 如何知道欄位的型態: Using SQL Server: SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'yourTableName' AND COLUMN_NAME = 'yourColumnName' Mysql 可以使用 show create tableyourTableName; 來取得 mssql