You can query sysobjects table. The field "type" holds all the object types in the database (Tables, procedures, triggers, constraints etc., identified by type). The datatypes of the columns of table can be checked by sp_help tablename
[font="Verdana"]Renuka__[/font]