Home Forums SQL Server 2008 T-SQL (SS2K8) Information_Schema.Columns on All Database RE: Information_Schema.Columns on All Database
jeetsingh.cs
SSCommitted
Points: 1741
More actions
November 6, 2012 at 12:03 am
#1556317
EXEC sp_MSforeachdb 'use [?];
select * from information_schema.columns
'
😎