how to select decima precision and scale value from table?
how to select decima precision and scale value from table?
USE dbname column_name 'Column Name',data_type 'Data Type',CHARacter_maximum_length 'Maximum Length',COLUMNPROPERTY (OBJECT_ID(Table_Name),Column_Name,'IsIdentity') as FieldIdentity FROM information_schema.columns WHERE table_name = tbname;
with this if the data type is decimal i want that values also ..how to list .
eg:decimal(4,2)
how to select that precision and scale from table