anjumathi kumar

anjumathi kumar

  • NA
  • 54
  • 64.4k

how to select decima precision and scale value from table?

Jun 24 2011 2:44 AM
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


Answers (1)