Data Dictionary Using Query SQL

Posted: Tuesday,May 12, 2009 in SQL 2005

select distinct b.name, a.name, c.name, a.max_length,c.precision, c.scale
from sys.columns a left join sys.objects b
on a.object_id = b.object_id
left join sys.types c
on c.system_type_id = a.system_type_id
and c.user_type_id = a.user_type_id

Having A Nice Try… ^^

Good Luck

Comments
  1. layyuddi says:

    wah untuk yg skripsi udah terlanjur buat phisical database, bisa dibuat kamus datanya nih

  2. wihemdra says:

    sir, yes sir. Jadi inget masa2 ngerjain data dictionary waktu skripsi…><"

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s