Professional Web Applications Themes

default vales - Microsoft SQL / MS SQL Server

Hi, How can I find table name, column name of all columns having default value '' Is there any system table store the defalt values. Thanks...

  1. #1

    Default default vales

    Hi,
    How can I find table name, column name of all columns having default value
    ''
    Is there any system table store the defalt values.
    Thanks


    Abraham Guest

  2. #2

    Default Re: default vales

    Try,

    select table_name, column_default
    from information_schema.columns
    where column_default = '('''')'

    HTH
    Prasad


    "Abraham" <com> wrote in message
    news:phx.gbl... 
    value 


    Prasad Guest

  3. #3

    Default Re: default vales

    Include the column name as below,

    Try,

    select table_name, column_name, column_default
    from information_schema.columns
    where column_default = '('''')'

    HTH
    Prasad

    "Abraham" <com> wrote in message
    news:phx.gbl... 
    value 


    Prasad Guest

  4. #4

    Default Re: default vales

    Binu,

    SELECT column_name,table_name,column_default
    FROM information_schema.columns
    WHERE column_default = '('''')'
    OR column_default = '(space(0))'

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

    "Abraham" <com> wrote in message
    news:phx.gbl... 
    value 


    Dinesh.T.K Guest

Similar Threads

  1. question about the default.mxml and Default.mxml
    By guru~k in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: June 15th, 03:00 AM
  2. Replies: 4
    Last Post: April 9th, 05:53 PM
  3. set a default for INC
    By Sam in forum PERL Miscellaneous
    Replies: 2
    Last Post: September 19th, 04:40 PM
  4. [PHP-DEV] Get value if set, or default
    By Robert Cummings in forum PHP Development
    Replies: 4
    Last Post: August 19th, 05:56 AM
  5. PK and Default
    By Vlad in forum Microsoft SQL / MS SQL Server
    Replies: 6
    Last Post: July 24th, 01:50 PM

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