SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

2
kudos

Kudos

Ozziemedes on SQL Server: Mastering the Metadata Part 1 (Tables #2)

published 838 days, 21 hours, 47 minutes ago posted by

http://ozziemedessql.blogspot.com/ 848 days, 6 hours, 43 minutes ago

Ozziemedes on SQL Server: Mastering the Metadata Part 1 (Tables #2)

n the last Metadata-themed post to my SQL blog, I discussed some of the metadata used to define tables – with particular emphasis on their storage. I didn’t go deep into what the metadata available in the storage-specific tables describes, but I did give a brief description of their purpose and the kind of information they contain. Today, I want to focus in more on the logical structure of tables, with a view towards being able to reverse engineer DDL statements to create a copy of the table.

I’ve ...

category: Query | clicked: 1 | | source: ozziemedessql.blogspot.com | show counter code

tags: Catalog Views, SQL 2008, sys.columns, Sys.tables, sys.types, System Catalog

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

Ozziemedes on SQL Server: Mastering the Metadata Part 1 (Tables #2)

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up