Hi,<BR><BR> How can I obtain data type of any column name. I also want to know whether a field in a record has any default value or not and if any present then how to get that value<BR><BR>cheers<BR>Dharmesh
if you are using SQL Server you can execute SP_TABLES and specify the table name in the stored procedure
I can't get you<BR><BR> I want to do it using ASP and I don't understand what you want to say.
Thank YOU MJ<BR><BR>After all I get what i required by using other stored procedure<BR><BR>sb_columns