Sunday, May 4, 2008

Command for describe table

SQL Server

Syntax:
SP_HELP <tablename>

SP_COLUMNS <tablename>


Oracle
Describe an Oracle Table, View, Synonym, package or Function.
Note: that because this is a SQL*Plus command you don't need to terminate it with a semicolon.

Syntax:
DESC table

DESC view

DESC synonym

DESC function

DESC package

14 comments:

  1. Hello everybody! I don't know where to start but hope this site will be useful for me.
    I will be happy to get any assistance at the start.
    Thanks in advance and good luck! :)

    ReplyDelete
  2. i truthfully enjoy all your writing style, very exciting,
    don't quit and keep writing for the simple reason that it simply worth to look through it,
    looking forward to view additional of your current web content, have a pleasant day ;)

    ReplyDelete
  3. Today, I went to the beach with my kids. I found a sea shell and gave it to my 4 year old daughter and said "You can hear the ocean if you put this to your ear." She placed the shell to her ear and screamed.

    There was a hermit crab inside and it pinched her ear.

    She never wants to go back! LoL I know this is completely
    off topic but I had to tell someone!

    my page ... velvelonmedia.com

    ReplyDelete
  4. Hi, I read your new stuff regularly. Your humoristic style is witty, keep
    doing what you're doing!

    My web site; breast actives

    ReplyDelete
  5. I'm impressed, I must say. Rarely do I come across a blog that's equally educative and engaging, and without
    a doubt, you've hit the nail on the head. The problem is something not enough men and women are speaking intelligently about. I am very happy I came across this in my hunt for something regarding this.

    Here is my web blog; capsiplex

    ReplyDelete
  6. Hiya! I just would like to give an enormous thumbs up for the
    nice information you have got here on this post.

    I will be coming back to your blog for extra soon.

    Check out my weblog: semper fido

    ReplyDelete
  7. Howdy! I just would like to give a huge thumbs up for the good data you might have here on this post.
    I will likely be coming again to your blog for
    more soon.

    Also visit my site pc semi sweet chocolate chips vegan

    ReplyDelete
  8. Good day! I simply would like to give a huge thumbs up for the good
    info you’ve got here on this post. I can be coming again to your blog for
    more soon.

    my site :: seo book pdf in hindi

    ReplyDelete
  9. Hey! I just would like to give an enormous thumbs up
    for the great data you’ve gotten right here on this post.

    I might be coming back to your weblog for more soon.

    my website: megan fox seoul premiere pics

    ReplyDelete
  10. Hi there! I simply wish to give a huge thumbs up for the good data you may have right here on this
    post. I might be coming back to your weblog for more soon.


    Feel free to visit my web blog; semana santa 2012 en mexico

    ReplyDelete
  11. Hello! I just wish to give a huge thumbs up for the great data you may have here on this
    post. I might be coming back to your weblog for extra soon.


    Here is my weblog :: semolina wheat recipe

    ReplyDelete
  12. Hey! I just wish to give a huge thumbs up for the great data you’ve gotten right
    here on this post. I might be coming again to your blog for more soon.


    Feel free to visit my webpage; melting semi sweet chocolate chips microwave

    ReplyDelete
  13. Howdy! I simply want to give an enormous thumbs up for the good information you’ve gotten right
    here on this post. I might be coming back to your blog for more soon.


    Also visit my weblog; definition of semantics pragmatics

    ReplyDelete
  14. I'm no longer certain where you are getting your info, but great topic. I needs to spend some time learning more or working out more. Thanks for magnificent info I was on the lookout for this information for my mission.

    Feel free to visit my site body detox diet

    ReplyDelete