SQL statement for determining the field type

--> Title: Generating test data
--> Author: wufeng4552
--> Date: 09:56:07
If object_id ('tb') is not null drop table tb
Go
Create table tb (ID int, name text)
Insert tb select 1, 'test'
Go
-- Method 1
Copy codeThe Code is as follows:
Select SQL _variant_property (ID, 'basetype ') from tb

-- Method 2
Copy codeThe Code is as follows:
Select object_name (ID) Table Name,
C. name field name,
T. name data type,
C. prec Length
From syscolumns c
Inner join policypes t
On c. xusertype = t. xusertype
Where objectproperty (id, 'isusertable') = 1 and id = object_id ('tb ')