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,639 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,070 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 Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...