>Ok i know its a question for sql server
>but i want to see the list of all my table
>
>i know in oracle is
>select * from sys.tab
>
>but in sqlserver ???
The "rough" equivalent is:
Select * From SysObjects Where Type='U'
But I tend to prefer INFORMATION_SCHEMA as given by Sergey.