Professional Web Applications Themes

information_schema - Microsoft SQL / MS SQL Server

Hi, can someone tell me how to drop a table using the information_schema.tables view. Thanks Chuck...

  1. #1

    Default information_schema

    Hi, can someone tell me how to drop a table using the
    information_schema.tables view.

    Thanks
    Chuck


    Chuck Guest

  2. #2

    Default Re: information_schema

    You use a DROP TABLE command, not a view.


    "Chuck" <state.nh.us> wrote in message
    news:phx.gbl... 


    Aaron Guest

  3. #3

    Default Re: information_schema

    Chuck,

    It should be ......and table_type = 'base table' , no underscore in between

    --
    Dinesh.
    SQL Server FAQ at
    http://www.tkdinesh.com

    "Chuck" <state.nh.us> wrote in message
    news:phx.gbl... 
    tables. 


    Dinesh.T.K Guest

Similar Threads

  1. View definition truncated in information_schema
    By Eric E in forum PostgreSQL / PGSQL
    Replies: 1
    Last Post: January 27th, 07:28 PM
  2. Problems with information_schema
    By Marcel Gsteiger in forum PostgreSQL / PGSQL
    Replies: 1
    Last Post: December 12th, 06:33 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139