get all table's information concerned 1 get all columnname select [name] from syscolums where id=object_id('tablename) 2 get all tables select [name] from SysObjects where type='U' 3 get all datatype of system select [xtype],[name] from SysTypes