As a DBA I need to see the list of tables available in a particular database frequently. Traditionally, this can be done by traversing through the object explorer. This may be the popular method among GUI lovers. But for me it is a pain. I hope it is the same for most of the DBAs.
I use a different method to see the list of tables in a database using a shortcut key. I've assigned the below SQL statement to a shortcut key.
select SCHEMA_NAME(schema_id) [Schema],name from sys.tables order by SCHEMA_NAME(schema_id),name
To access, the shortcut key use the following steps;
1. Tools
2. Options
3. Select Keyboard from the left pane.
4. Assign the above SQL statement to a shortcut of your choice
Subscribe to:
Post Comments (Atom)
How to interpret Disk Latency
I was analyzing IO stats in one of our SQL Servers and noticed that IO latency (Read / Write) are very high. As a rule of thumb, we know tha...
-
Sharding is a data partitioning technique which is popular in NoSQL databases like MongoDB and Cassandra. You can scale out the data set h...
-
I'm super excited to hear about the news, the first release of CTP (Community Technology Preview) of SQL Server on Linux at Microsoft ...
-
In-Memory OLTP, code named Hakaton is a separate database engine introduced in SQL Server 2014 and it is combined with SQL Server traditio...
No comments:
Post a Comment