create table ClientAttributes
(
    Age int not NULL check( Age > -1) ,
    Weight numeric(10,2) not NULL check( Weight > 0),
    Handed varchar(5) not null check( Handed in ('left', 'right')),
    QuitDate datetime null, 
    HasInsurance bit not null default(1)
)

go
-- create an XML schema from the table with client attributes
DECLARE @mySchema xml 

-- this is the default schema that gets created from the ClientAttributes table
-- however the check constraints aren't converted
SET @mySchema = (SELECT * FROM ClientAttributes FOR XML AUTO, ELEMENTS, XMLSCHEMA('ClientAttributes'))
-- see the schema that gets auto-created
select @mySchema