• for table variables, you can create unique constraints, but you cannot name them.

    i don't think they allow default or check constraints either.

    only temp tables or regular tables will allow a named constraint in the definitions.

    this was the first link i found stating the same:

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=131034

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!