List all tables and their respective information.
List all tables in a SQL Server database with the details of them.
2015-10-13 (first published: 2013-02-20)
4,467 reads
List all tables in a SQL Server database with the details of them.
2015-10-13 (first published: 2013-02-20)
4,467 reads
Simple script which create a list of all the tables and rows of the selected DB.
2013-02-11 (first published: 2012-12-21)
1,069 reads
This code helps in finding Primary Keys for all tables in a database.
2012-10-02 (first published: 2012-09-04)
1,414 reads
Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.
2009-10-15 (first published: 2009-10-01)
1,677 reads
Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.
2009-10-06 (first published: 2009-09-22)
1,158 reads
Part 2 of how to add a computed column to a table. MVP Andy Warren narrates this SQL School video.
2009-06-25
4,262 reads
In this SQL School video, Andy Warren shows how you can alter a table to add a computed column. This is part 1 of 2.
2009-06-23
4,629 reads
Learn how to use the SSMS GUI to modify tables in this SQL School video.
2009-03-03
3,053 reads
Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.
2009-10-02 (first published: 2008-11-05)
1,116 reads
Searches for tables who's names contain the search string. Gives Aggregate Size, Rows, Index, and Column information as well.
2009-10-20 (first published: 2008-11-04)
877 reads
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
I'm sure this has been asked many, many, many times and hoping several optimal...
How do I determine the initialization status of a subscription with T-SQL -- i.e,...
Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...