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,315 reads

Blogs

Azure Database for PostgreSQL

By

Having worked with Azure SQL Database and its many flavours for couple of years...

Why I Support Code Automation Tools Like ORMs

By

I know I’m a weirdo. I’ve always been a weirdo. When I was a...

#PowershellBasics: Run a file and pass it a parameter.

By

I realized in my last #PowershellBasics post that I was talking about running a...

Read the latest Blogs

Forums

Index maintenance in availability groups

By garryha

I have a 4 node always on availability group setup across two datacentres with...

Extract part of string

By Mad-Dog

hi, How can I extract part of this string declare @string varchar(1024) set @string...

Data type conversion error

By as1981

All, This is my data flow: I'm getting the error: "Error: 0xC02020A1 at Data...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers