Tuesday 11 October 2011

SQL Constraints

01:45    8 comments

SQL Constraints

Constraints are used to limit the type of data that can go into a table.

Constraints can be specified when a table is created (with the CREATE TABLE statement) or after the table is created (with the ALTER TABLE statement).

We will focus on the following constraints:

  • NOT NULL
  • UNIQUE
  • PRIMARY KEY
  • FOREIGN KEY
  • CHECK
  • DEFAULT

The next chapters will describe each constraint in detail.



8 comments:

  1. Anonymous11 September 2014 at 05:33

    Hi there all, here every person is sharing such know-how, therefore it's good
    to read this weblog, and I used to visit this blog every day.


    Also visit my web-site: play minecraft free

    ReplyDelete
  2. Anonymous26 September 2014 at 06:45

    Wow, this post is good, my sister is analyzing these things, so I am going to tell her.


    Here is my blog post :: Quest Bars

    ReplyDelete
  3. Anonymous29 September 2014 at 06:54

    Undeniably believe that which you stated. Your favorite reason appeared to be on the web
    the simplest thing to be aware of. I say to you, I definitely get annoyed while people consider worries that they plainly don't
    know about. You managed to hit the nail upon the top and
    defined out the whole thing without having side effect
    , people can take a signal. Will likely be back to get more.
    Thanks

    Feel free to surf to my web page - Quest Nutrition Quest Protein Bars

    ReplyDelete
  4. Anonymous2 October 2014 at 04:26

    Hi there to every single one, it's actually a good
    for me to go to see this web page, it includes valuable Information.

    Feel free to visit my blog :: quest Bars

    ReplyDelete
  5. Anonymous10 October 2014 at 02:52

    This is really interesting, You are a very skilled blogger.
    I've joined your feed and look forward to seeking more of your wonderful post.
    Also, I've shared your web site in my social networks!


    my site - Diet Plans for Women to Lose Weight

    ReplyDelete
  6. Anonymous14 October 2014 at 13:09

    I'm not sure why but this site is loading extremely slow for me.
    Is anyone else having this problem or is it a issue on my end?

    I'll check back later and see if the problem still exists.


    my page; Diet Plans for Women to Lose Weight

    ReplyDelete
  7. Anonymous18 October 2014 at 01:54

    Hi there everyone, it's my first pay a quick visit at this website, and piece of
    writing is truly fruitful for me, keep up posting these content.



    Feel free to surf to my blog Diet Plans to Lose Weight

    ReplyDelete
  8. Anonymous21 October 2014 at 04:55

    Someone necessarily lend a hand to make significantly articles I
    would state. That is the very first time I frequented your web page and up to now?
    I surprised with the analysis you made to make this particular post amazing.
    Fantastic activity!

    Feel free to surf to my blog post :: best dating sites

    ReplyDelete

Subscribe to: Post Comments (Atom)