SQL statement used to query data table Field Names

The following is a query statement for viewing the field information of a table in SQL Server (taking the database pubs's jobs table as an example)
Select sysobjects. Name as tablename,
Syscolumns. Name as columnsname,
Policypes. Name as datetype,
Syscolumns. length as datelength,
Sysproperties. value as remark -- column description
From sysobjects,
Policypes,
Syscolumns
Left join sysproperties
On (syscolumns. ID = sysproperties. ID and syscolumns. colid = sysproperties. smallid)
Where (sysobjects. xtype = 'U' or sysobjects. xtype = 'V ')
And sysobjects. ID = syscolumns. ID
And policypes. xtype = syscolumns. xtype
And policypes. Name <> 'sysname'
And sysobjects. Name = 'job'