Phil shows how to start squeezing powerful magic from SSMS for doing a detailed exploration of the metadata of your routines and tables, In this third part to the series on exploring your database schema with SQL.
2010-05-19
3,433 reads
Learn how to get column names, data types, indexes, foreign keys, triggers and more in one snappy overview from new author Jacques Bosch
2009-03-23
8,656 reads
This Script has been build to list all the tables in a database without using a cursor.
2009-08-03 (first published: 2009-01-05)
2,071 reads
One of the issues I often face is the need to find views that are already established for certain tables. This maybe for other developers, end users or even for myself. I could search the system tables to find this or explore each view, but are there other ways to easily find a list of all tables that are used for a view or even a list of all views that a table is tied to?
2008-12-12
3,940 reads
use metadata to generate basic create procedure statements for insert update and select
2008-11-22 (first published: 2008-10-10)
3,822 reads
Quick way to get all users on all Databases
2009-08-05 (first published: 2008-06-06)
1,669 reads
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
We value your privacy. This policy explains what personal data we collect and why. What...
Comments posted to this topic are about the item The Subtle Differences Between COALESCE...
Comments posted to this topic are about the item SQL Server Collations
Why would using variables in place of hard coded numbers impact a query's performance? ...
At what levels can we set the collation in SQL Server 2022?
See possible answers