Wednesday, February 13, 2008

Generate or create XSD Schema from Database Table in sql server 2005

create table Person
(
Age int not NULL check( Age > 0) ,
Height numeric(10,2) not NULL check( Height > 5),
Gender varchar(5) not null check( Gender in ('M', 'F', 'O')),
BirthDate datetime null,
)
DECLARE @schema xml
SET @schema = (SELECT * FROM Person FOR XML AUTO, ELEMENTS, XMLSCHEMA('PersonSchema'))
select @schema
OUTPUT:

8 Comments:

At 8:17 AM, Blogger Imran Akram said...

That's a very helpful post my friend, thanks a lot. I gained something from it

God Bless!

 
At 2:34 PM, Anonymous Anonymous said...

The reverse

http://xml2ddl.berlios.de/

 
At 2:14 PM, Blogger ifmo114 said...

Any tips on doing this on an entire database resulting in one XSD file?

 
At 2:59 AM, Blogger stafford said...

alo interested in something that will generate for the entire database schema, rather than just a table...cheers.

 
At 1:57 AM, Anonymous Cheap WOW Gold said...

Eden Eternal
Eden Eternal Gold
Eden Eternal Review

 
At 1:42 AM, Anonymous gamingwow said...

Thanks for sharing and letting us aware about this information. This is a great thread, so much info.it ls a good article and love your words , so charming and make people learn a lot , thanks !The following are my recent blogs posts:

http://goldjoy.xtrablog.dk/world-of-warcraft-gold-may-be-the-standard-currency-of-world-of-warcraft-post241327
http://oshineme.unblog.fr/2011/12/02/rs-gold-guide-is-necessary-for-each-player/
http://band.org/friendshere/blog/where-can-players-get-rs-gold-guide/
http://shienno.quebecblogue.com/2011/12/01/how-to-create-more-rs-gold/
http://whostera.asso-web.com/actualite-13-numerous-runescape-gamers-are-battling-to-create-rs-gold.html

 
At 8:22 PM, Anonymous Anonymous said...

I LOVE my boyfriend with cambridge satchel us ALL the world. I dont think it would be possible to love him anymore. We've had a really strange weekend because we have hardly spent any time together at all!! I went out friday, hermes handbags outlet saw my grandma yesterday after work and had a catch up with my mum today. I only saw him after work for about 30 mins - 1hr! Now this is very unusual for us! And surprisingly hermes birkin cheap, it doesnt feel that bad! I think its because I have had messages from him all weekend long, telling me not to forget how much he loves me, or how I am HIS woman and no one elses! All these little things hermes handbags discount keep me happy even though im not seeing him!

 
At 10:56 PM, Anonymous Anonymous said...

As I Was Saying This Friday, This week end We had a very special party: a 80's party. It was a lot of fun, With all the ingredients to be a great party: laughs, meetings, sing star and the cops visit! To choose the costume i Have Been inspired by Madonna and Patricia Field's work in SATC 2. cameroon jersey 2012
cameroon jerseys wholesale
cameroon jersey for sale
england jerseys soccer
england jerseys sale
england soccer jersey cheap
france soccer jersey wholesale
france jersey euro 2012
france national team jersey
france jersey sale
germany national team jersey
germany jersey 2012
germany soccer jersey
italy jersey euro 2012
italy jersey soccer shirt
italy euro 2012 jersey

 

Post a Comment

<< Home