Skip to content

Instantly share code, notes, and snippets.

View kmoormann's full-sized avatar

Kevin Moormann kmoormann

View GitHub Profile
@kmoormann
kmoormann / SimpleSchema.sql
Created September 5, 2012 01:45
Simple Schema Output for MSSQL
SELECT
s.name [Schema Name],
tables.name [Table Name],
c.name [Column Name],
ISNULL(i.is_primary_key, 0) [Is Primary Key],
t.Name [Data type],
c.max_length [Max Length],
c.precision ,
c.scale ,
c.is_nullable,