doubt

[JayK]

Dear all,
 
                     we use  "select * from tab" to list all objects in a particular user in oracle.
could you tell me the equivalent query in sql server ?
 
Regards
Jai