Query to fetch the table names

[VIJSQL01]

hi,

Is there any query i can use single query to fetch all the table names present in a whole database. This i need to perform on SQL database. I am finding it difficult to copy from the table tree view on the left hand side of the SQL for listing out all the tables avaialable, since it has got so many data tables.

Thanks,
Vijay

 

[imex]

Try something like that:

SELECT name FROM sys.Tables WHERE IS_MS_Shipped = 0

I hope this helps.


Imóveis a venda em Suzano

 

[VIJSQL01]

Thanks a ton. I am able to get the list of all the tables.

Best Regards,
VIJ