Select name + "," From syscolumns where object_name (ID) = 'equipment'
'Equipment' is the table name.
The output format is changed to text.
The result is as follows:
Else ---------------------------------------------------------------------------------------------------------------------------------
Activestatus,
Address,
Adviceboard,
Aspset_key,
Assettag,
Attachment,
Attachment_des,
Attribset,
Bovvalue,
Businessunit,
City,
Comments,
Computer_type,
Contactequipment,
Contractcoverag,
Country,
Custfield0,
Custfield1,
Custfield2,
Custfield3,
Custfield4,
Custfield5,
Custfield6,
Custfield7,
Custfield8,
Custfield9,
Custfieldsavail,
Custlabel0,
Custlabel1,
Custlabel2,
Custlabel3,
Custlabel4,
Custlabel5,
Custlabel6,
Custlabel7,
Custlabel8,
Custlabel9,
Customerequipment,
Customerid,
Datecreated,
Datemodified,
Debtornr,
Deliverdate,
Deliverynumber,
Deliveryposition,
Details,
Division,
Equip_warranty,
Ethernet_id,
Fsident,
Glaccount,
Harddisksize,
Haswarranty,
History,
Hwcontract,
Hwcoverage,
Installdate,
IPaddress,
Islock,
Linktype,
Location,
Maintenance_level,
Makemodel,
Nodename,
Notes_key,
Ordernumber,
Orderposition,
Ordertype,
Orgequipment,
OS _type,
OS _version,
Perlewbz,
Pkey,
Port_number,
Priority,
Prod_warranty,
Productequipment,
Project_id,
Purchasedate,
Pwarranty_expires,
Ramsize,
Sap_info,
Satok,
Serialnumber,
Serregequipment,
Servername,
Slaavailfactor,
Snail _address,
State,
Type,
Validdate,
Vendor,
Warranty_expires,
Warrantycoverag,
Workgroupequipm,
Zip,
(The number of affected rows is 96)