• Interests: Sailing, boats, wooden boats, wooden boats with sails - oh, and sailing

Get all Tables and Columns for each Database

This script will get the name of each database from master..sysdatabases, then use each database's Information Schemata to get the tables and columns in each of the databases. Several recent requests for assistance have used this to answer their needs. I ran it across 245 databases and pulled back 1.4 million results in about 30 […]

5 (1)

2004-04-15

1,318 reads

Blogs

Daily Coping 2 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Updated Pluralsight Course – Kubernetes Installation and Configuration Fundamentals

By

My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want...

Power BI and a Star Schema

By

I sometimes get asked from customers if they should use a star schema or...

Read the latest Blogs

Forums

[ADO NET Source [2]] Error: The ADO NET Source was unable to process the data. F

By yrstruly

I am trying to get data from myslq into mssql with ssis. I am...

xp_cmdshell

By ramyours2003

how to check which job or  stored procedure using xp_cmdshell in sql server ?

consolidate error logs

By ramyours2003

i need to configure job to consolidate sql error log sizes   from multiple servers...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Adding N/A

See possible answers