What is the command to view all tables in SQL Server?

1 year ago

Liam

1 minute

In SQL Server, you can use the following command to view all tables:

SELECT * FROM sys.tables;

This will return a result set containing all table information. If you only want to view the table names, you can use the following command:

SELECT name FROM sys.tables;

This will return a result set containing only table names.