Write SQL query to retrieve all tables of the database

Write SQL query to retrieve all tables of the database.

- There are many ways to retrieve all the tables from any database like MySQL and SQL server.
- In simple term you can get table names either from INFORMATION_SCHEMA or sys.tables.
- It is based upon whether you are using MySQL or SQL Server database.

Following query is the easiest way to retrieve all the tables of the database:
SELECT name FROM sysObjects WHERE xtype='u';
Define Local temporary table and global temporary table
Local temporary table is created by prefixing name with pound sign like (#table_name).......
When do we use the UPDATE_STATISTICS command?
UPDATE_STATISTICS updates the indexes on the tables when there is large processing of data........
Difference between clustered and non-clustered index
Both stored as B-tree structure. The leaf level of a clustered index is the actual data where as leaf level of a non-clustered index is pointer to data.......
Post your comment

Related Content

Follow us

▲