Data Table field attribute query, data table field attribute

Data Table field attribute query, data table field attribute

--- Query all database table names
Select id, name from sysobjects where xtype = 'U' order by name
--- Query all the field attributes of a table
Select * from syscolumns where id = object_id (n'fms _ payapplies ')
--- Query the table field name, type, length, default value, whether to allow null
Select column_name, data_type, CHARACTER_MAXIMUM_LENGTH,
COLUMN_DEFAULT, IS_NULLABLE
From information_schema.columns
Where table_name = 'wf _ WORKFLOW_STEP'