How to get a list of all tables with "sys.tables" view in ms sql serve

How to get a list of all tables with "sys.tables" view in ms sql server?

Question Posted / sanjeev saxena

No Answer is Posted For this Question
Be the First to Post Answer

More SQL Server Interview Questions

Explain active/passive and active/active cluster configurations?

What are the restraints imposed on the table design by a merge replication?

How many categories of data types used by sql server?

What is blocking and how would you troubleshoot it?

how to overcome kernel isssues

How to find the version of sql server? : sql server database administration

Explain what are the basic functions for master, msdb, model, tempdb databases?

define and explain the differences between clustered and non-clustered indexes.

How to optimize stored procedures in sql server?

What is rtm version in sql server?

How can I know what locks are running on which resource?

How to list all dsn entries on your local machine using odbc_data_source()?

For more SQL Server Interview Questions Click Here