Category >
MYSQL
|| Published on :
Friday, February 26, 2016 || Views:
9884
||
Sql query Script to get the columns with datatype of tables with default values
Introduction
Here Pawan Kumar will explain how to Sql query Script to get the columns with datatype of tables with default values
Description
In previous post I have explained
How to bind dropdown list with XML file in asp.net?,
Validate ASP.Net form using CSS in C#,
API Demonstration ASP.NET,
Age Calculator using ASP.NET & C#,
How to Access AppSettings in Code Behind File,
Increse Decrease Font Size or Zoom In Zoom Out Text Size Using jQuery, and many more articles.
Now I will explain How to Sql query Script to get the columns with datatype of tables with default values
So follow the steps to learn Sql query Script to get the columns with datatype of tables with default values
Sql query Script to get the columns with datatype of tables with default values
Note: for this example we will use northwind database from microsoft website.
Step 1: Right click on the northwind database and click "New Query" the write the below query:-
SELECT TableName=Table_schema+'.'+Table_Name,
ColumnName=COLUMN_NAME,DataType=UPPER(DATA_TYPE)
+CASE WHEN CHARACTER_MAXIMUM_LENGTH IS NULL THEN ' ' ELSE '('+CONVERT(VARCHAR(5), CHARACTER_MAXIMUM_LENGTH)+') ' END
+CASE WHEN IS_NULLABLE='YES' THEN 'NULL ' ELSE 'NOT NULL ' END+CASE WHEN Column_Default IS NULL THEN '' ELSE 'DEFAULT('+Column_Default+'),' END
FROM INFORMATION_SCHEMA.COLUMNS WHERE Table_Name='CustomerCustomerDemo'
Output will be like below screenshot:-
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABF4AAAGdCAIAAACkYiAVAAAgAElEQVR4nO3du47cVtrucd6QBAGKhpFvwIGAVvxlC842FHiUOOgLMCAGghrtyMFgnLgTecBsAKOBjW8w6kAYGG1sEA6MiSRNYGWTvTvgaR3edWAdmqzu/w8v7FYVD4tkHdZTi6yqzgEAAADgwat+ef8PiqIoiqIoiqKoB15EI4qiKIqiKIqiqD2i0drjXdiW1R/KFEVRFEVRFLVP7RKN+q6wABbSEUVRFEVRFHXStSwaEYqQQDqiKIqiKIqiTrcWRKMHF4paU1VVZdqyqbumLp84v6SqbrrdG+PP5y1s2TzqIrqmDlpDNKIoiqIoiqJOt0qjkZOL+r7yaOwz27eOnWa9Q69NeQxqxii3MI342cjdSwuaccBo1JrIAXIXFqzRu8H5Z9fUVVUbU9dNY5zFEI0oiqIoiqKo062iaKTkIj3t9LdafysTR6Y8MCsG3FU08rNRejfklnOIaNQvaJpHXURsR3nzev8M/i0iRCOKoiiKoijqlCsfjbzz6NR+e3SQIeiNl0zpzGQPdfSzTfO0pqrq2l6et/T4yWThUr0hFdPukEbcbDTPbjWr/9MLI84WmdaafGjVcNe4ud6uiGVAP77Et0fbUf3g0HTT/E9GjSiKoiiKoqj7WJlopFxfpJ1N53e6p38HvfGSKb1MMXTPp3PDhuTQhwTTWjPqWSCIRkq6U9e+fKCmNUEwc8JWpBXeFjlJyR1gs/KSuzwtsbZucPEaZM+v7ihvdu+fXGtEURRFURRF3a9KRaP49y74newjRSN3UKRybw1HZ4KTvJLRKBbt9olGTjaKnDmojPR4W2QnJS9oBaNqqXEjPxr5OyCTIZ3rlIJ/aohGFEVRFEVR1OlWNBoVfR/dOFbRHueEOv1rFCLfGWBM0HdPfDub+00QB4tGdjYKE4y7o+asoe6UcRQpXJq6f5TkEo1GwS7cYdRIQzSiKIqiKIqiTrf0aFT6Pd16jEif+5Wc0ptpCDC5c8fmoRMlG8QuRJpvcq7uSUWjabLwD2edwVCUd4qcn4dieXHMSN6e9EbatEXMy7HzT3RPLLrWKI5oRFEURVEURZ1uKdEonYviX0kdfrVBbGptyuDsuSGShGeMRS+rCU8Rc5bmJw5n/drad4pG81cxZLbdOmEu/lXZY7Ocga3gT3dpXrrxvkjd273Rb/TeIRkRjSiKoiiKoqgTLj8a7fu7ruU/JbTnjw4pyzrMt4Dv+4Xih/vp1wMouEBIlfpdoziiEUVRFEVRFHW65USjfXOR1Y2uCrrS5VMWrfIwKWv/31raVDZKXW9VOk/xIohGFEVRFEVR1OnWHI0OkovwkBGNKIqiKIqiqNOtIRqRi7A/ohFFURRFURR1ulWdn5+Ti3AQ5wAAAMDJSv3ka7pEqrEAAAAA4LQRjQAAAACAaAQAAAAARCMAAAAAEKIRAAAAAAjRCAAAAACEaAQAAAAAQjQCAAAAACEaAQAAAIAQjQAAAABAiEYAAAAAIEQjAAAAABCiEQAAAAAI0QgAAAAAhGgEAAAAAEI0AgAAAAAhGgEAAACAEI0AAAAAQIhGAAAAACBEIwAAAAAQohEAAAAACNEIAAAAAIRoBAAAAACyZzQ6L7P2Np6q1lRVVdVNl5skO9n9d4r7qmvqvjVrNySia6SqpKplh721z7zLneLRBwAAG7RvNMquYLdoZCqpxmoaGXqP7XyjXbF7TWstMT2vtt5WxFTSikgntTZvVRdsydD/DZR1iLumLunJFU4WNmrYRXYjnb12tza5r46ra+pVo9Gn64uL60/6fUO8MbssNzevst4TPPobfR4BAIBdbTEaGTvVtH6AGeLKqGuUeBPrlaTmbd001c4BSTqpxxTUmnEa68YUq+/bGqsLtXqHb/yk3b5h5cyw2X11PFuORuFzb4HMvHo0OsWjv8HnEQAA2NX2olHrj8Z44edI0aipxe/PdFLfQTTyPix3P2weenLz2UB6ryvW4bPmCxbdmsq0TT0v0OnSxVo1dgSHu007rcNeenS9t1exsy6vbje8r7Kchhljwn1t3d24W1Q3icEGvVUlRyG5rybJaCRSe2OvSyTn3SUabfPor/I8AgAAx7G9aOSNGmn3tu4fsQkWzJvOOXc4atQa5xPorqnrurZ7RXYnzF2JcmPQz7L+3bfGmijxabfTqq6px35nU489NmvhmfUmbHZfZbhTtyaMKO5+93fm/M9+k+x+daxVuaOgNFHbjZloZKrgA4NiyXn3HzXaytHf4PMIAADsaovRSLxrjbroXTtEI33ewpxjR6PlWn8wQeP2BbumDnq0ymK0Dp+2Nvu28e+px5U6EajzBzqmZQyzzP243HrLbGtf5Rsb3XOZ06uCrr/VumSrMkchvaLY4N3VbWIrD6B0vad09Lf9PAIAAIscJholvphu32+o66SOXGtUOGpknymXGjWKByrbEaKRe9ZMFXwWHnSzwtuUybIXtc+tGTp1bpcu3qp0ly693vQJdZvdV1luu+zlZ3qziWiUblU+GqX21SQzanQ06fWe0tFf5XkEAACOY3OjRkr2aJ1vukoMCqkTqNEo1NRFmefQ0Sg4S+aon4XH7m9NVTdWly7Zqh0+7V5uW/tqGaedBx410maMHIXUvpqcTjTa6tFf9Xk0fNRwcb1z8wEAgG2L0cg7ic5LI8qAj/sVwQuikTuvd3FE//3Dfkw7fDQKrrsOr6Cwbim/gqLvcHmTaaNGw2Kt4Y5kq7LjFen1ltnWvkoKz2Jzbuj8VljXmKSjUbJVyzrW/r6a7B6N+ifqrr9ctFM02uLRX/d5dH1xfn6+SrYFAOB+2mI0Mo37O0JTeon8NtEwQezePvCk5+15v1/kXn1kEjNmt8k7KybxLVTDd1aZdrynbjr75BrvZC2FtXD/rJyxX6V8JZrTYY+3ar7d+j6w4TL0uXWx9Z7ivsoKT33KnLKlHIV5qMdbgt6qkqMQ31e2jUWjEzv6Kz+PPl1f3MEFYgAAPCSbi0YAgKxP1xcMGQEAcFhEIwA4PbdXDBkBAHBg+0ajEmtvIwAAAABk7BWNxgLuLf07lJdckYLTxdEHAOBBIRoBAAAAwKGjEafPAQAAADhFRCMAAAAAIBoBAAAAANEIAAAAAOQEo5H7M/IAELq9Or+4XrsR23V7xY/FAgCgWCsazQmnqkwrralMu6TdXVPfWTTqmnpqqPPv+aYVZfak1VbrDnumYDu8JXr/9naGs5a62WdfZed1W61upt6qcHursb0L9/CiGa0N2+GLnu3Nd9e9eFEHZKznfSvSWv80IiLSWLf0VVuzJ+5tg7v66je30+6KHgSv5585gonHVfYopOZNSy95Wm6wor7lytzTA6Pk0f7p+oLfiwUAILBGNGpNpXTTtxuNRMZGWr3S1mxg2Cq9J7umtvtD3j+HGSK7PbjH2uGtqUxdW4tqTVXXtdcz221flczbmsq0QQNzrQo2adFDyJu2qZcc/Z2jkdUtnuPi6j+n044paNKMAUadoHHTUfpe77cAvCXb97bRdPTp+iIcMsofQfVxVXgU9MdkUn7J4cccqadv19TVkkc7A0cAAIRWiEZKj7Rrav9NXv+s057Eu2OYaewcdPNAxtzhHm7rB1fsGDGFCmvVTs+iNf2AybRSp8vufYQ7zZldr73ycLW3V+cR/ee96T2phIrO6xDuHo3a1tg7zzSNE40S+yqtYN6haa1xx09yrTpoNHLaFTv6w2TKp/dOI2LzZrrO3iiCM+g2Pu46e/HhBuz2qFscjUSktjJM+t7yaCQiRkR7+F5fKJ3+1BEc/608rsqiUeQxmVSyZGuBsc8IIttY8Gi/vTpn4AgAANedR6Psx96tcXpxXVNrI0p6vzZY+DyVNWbS1JV1hlaQY+bprTX0PY108HC3wG5/Yr1eKnSblJTZk3rscZu9RzSaPnfvm9H50ahwX+nrTcxrrch9CORaNW/S4rM3g3WlNso5+kGb0/xHTrrr7AddpyfdNXVd28MIzjjJ7o86uatopP6UtH1jE5nmk5qMckcw9rgqCTDRx2RSWejqj5R/vPzZwm0seLRHdhQAAA/Z5qKRPhISzLJLNAo/f3V6HH730FnD2MGYJkp1973+a2q9WselsOue3pORezt1q0IF0ajfF6b/RxiNCvdVZL2xee32u/3FXKuCS6gWCR9u0UGncM+XnwUXmTJ2nLwYZu8P9/QqbzF7POpkeTRqkyfUtcEJdcrrinZvrU0g0cGQ9BGMP66slkb2UMm8ael97502G53NGbMqebQzbAQAgG+NaJTpBhR8OnqsaBQ/s3++c+i0B8MvkZOm0utNX4qdPrVplz2ZGTUK44+7a/375nEwLRpF9lXS0v2sHT69VUcYNRqXEj/6vVQ0ys3rr0uZ3TqD0DkpNdznw237POqkLBpV8ZCTvrdw1KiNfw1DcTRKHcHIcycSUPLzpmUekalkHFtvyaOdaAQAgG+Va41S/YBVR41KotEwv9VlD85G2nPUqFg2Gy291igRjdztDVarR6NwX+Wk592nVQW7eggF2pc+hw+38Zbk0Y/dMjcpN2+u6dPokNdCLTjvFQ6txQTRyOROqEvPblMTkXpvGxk4Kj6hruzR7txYEpgWPNrTS87enZqt4BBzQh0AAIFVvrxbuX5k7iI6p4WIRAJANBo5F/BXzrVDh4pG47dCRzpWrSkfNdK2VzsVKia5J70zcayrnvSt8q9VsO5L7ihvM5P7qmCD4vMmY/PyaNQ1tXvD9cX5eaSzGAaPoqM/Ta0flIJ5o9vmzDWeQeiu0x1IcJ4yez3qxm/uHubUxoUOFY06d+Lwaxi0Jpd8DYO9Nwo/jlGPQuG8aXcRjYJHO4NGAACEVvpdI++UnrCX5tzpDHMo3P6fffPQt66nG+umGxdi2nHqumm8H5Jt7X97y5xW43Q07eY0Y7fUWYy23k7Z3mU/XJPck1L8u0bu5ocTad/GNi7O/hY0Y3L7qmxTgnmtxug/KZNqlXV89YlF+g/R1b6ith7va8TsRTZBKHE3zf9atNS8waq1rrC6g/uuvzN/8lm27FEn8d8XarRfJSq5NzzRzv65pC64ZboxCFrBl3cnjmDmcTVdvqYdhcy8BTsxc3z9u61jlHiRjD673YXz5d0AAITW+slXYFs+XV/Ehow2Tr3oLPotEQ8C3f4cfvIVAAAN0QgQOeHTi/RrWx52NBrC0dqN2C6yIwAAKqIRcJK806aCi5b006gAAAAQQzTC3dG/Mzq4jgK4B3i0AwBwcohGAAAAAEA0AgAAAACiEQAAAAAI0QgAAAAAhGgEAAAAAEI0AgAs0zVSVVLVssNPZ+0z7zYVblFrJPxmwvu3Nw7iof0uWbC93m8zeL/BwO+SASV2fqasGY0+XV/EGm0qqcZqRUwl/QtDa+bbq/HGxLxNM74Ztc6MU5V8iW5Tj9PXIiLSSe3OPq2x6Zx729x6h7fFSobXPWveyhTuRfsl1LTSmuFFdLq9bjqRrqndl1j3ldd93Z0ntr5suNNXGfndnEirlCVb32Xsvxu46861KnkElaYON9ZNeovc/Zi8IVhEer3ePvL2WbbNKUGT9E3S9mbnrdje7fNS7EXUTdvU4wM6dXxzj8mM26vzgPsjvfYUV9fxlxfbp+sLZ1HTv8/Pz69unSXeemu4DZvktCd9b5r9UmBXPdy/6mvOtJTyGfabN/3qHdyrPp4O/r6wcItaPf/k5k28S87vwNX4T1tt3TvtkMa9pbOmMcEC7VXUIq07wVRNsKippu1V7+0Xq3D6M15nwLmlFkn3CrTnUfiuEetvpJ5lh1ivur0yLDz5svjp+uJYv1BOjyKPHsXJ9CgKninqa+z2olHrvre12utOK5WR1ihvgSaY1z7oxl1O15S9BXZSh6/grfV2FkzQ1M7rYGq9rdPjkchni7rWaI+u8YZufHjNrQqe+a2pTKu9Cru3tUZ51YjNm2iV1aR5Rqed/vI6p9EFrdK1pjJ1bU3dmqquvf0T26KuqZ3XjtaoL99dZP+m1huszFpIWZtTEm+vyf3cHzJrRa2xmtE1tb39/evR9EKWPr4lj8mcSGfx9srOHrdX5+fFHxf1Gcb61NbpqtxeeS+tQQOCKfylL+/EWC8p8wud/Tqz1muOvYgdf51px3mzr94m8mGZHOl9YVawRU0dmSAzb+xd0gk8rftW3FmJJfxnG2QSY93bWH9Pt9jBrQrubSL3tlY66qw1GiuYadHo0/WFN4QSHpGuCeJkslfQ2pPZKSXd38g9y3ZfryXcXslGoyMNHNGjoEeRcpI9iuwz5TSikfLS00ntvnUNL0Ot8+4uotzivaTu/BZof4w0f9x4qGhknPfN8m6K8sTpmnrJC9nwaGtN8LGB/0APnxOxeVOtOuwLWcH7hzOh9QLUmso0/v6J7w3rtSzyKhY0tWy9uReybJvzW112l/9CZtrGeg21X8hSYWbFaBSckZL6uD2c9+r2+mJ+Ab3/0WjX15xZHRmdOdq8u0ejo70vzLJbVMdHDZLz6g/jWvwBqM56KzZBvOmslNKKGJHamsa4Ocp7V/XWVR6NJJKCctHIfiZOrcpGlGivIDi+dozJ9DeOtl6bsr0lb23uZ0EHQY+CHkV+q8vu2lCPIvdMOYVopI7PeKxpwtcpk3yHshPOonfmYUWd1PWwdufts7iboqy3j1jWy3FpNyV4TGQn8B801gTB48l5oHupPjVvulULXsjUJ2GuVVHDjMOTs1+j19TU3hgWUdXOZy7axmkvZIn1Zl/I0m0u2+rkXfEP+Kw3xfmFzH6nDG1n1GiRPrxYI+/3KRod8jXHZlJnCB1j3uyrd+mo0fIlFzUusUVdk7qaKDmv+i4ZOQ9tVGk3Tvmnj0aJKDVFl35ib11V8Eds1Y07kFUYjT6pScHNFWEOyfUKrHeN1KCQLxuNdluvLbq98fOXkjPujh4FPYqyrU7etb0eRe6ZspFopF0xMJ2HXxCN7EyijKp755QHL1X6mcE5/atev+r+b+eVOndicWq94+hTa+Y/DhaN9JM/7QV087T+pyfhmZ0F8xY/0yJPMnu96gtZqlX5tbWmqozp/+E2Nbk35rUnOvKJF7LoegteyBJtLt1q/a74fnbWPPwxv5Dtc3z3OL17Eh8Osl9blnQaxvAypav1o5FF/7B5ldecVWVfvdPB5hjvC6WmHV0q8y6Zikaxexs3GomIsf6wj/40gbgxqRdejxS7N9bIcJm22Ecc1mka4TMi3Suwj6+TqUqiUfJZtuN6bUUf6TjnHy2acwF6FPQoCrdav2uzPQr1mZJ8jd3iqFHuzckEL1XxxCl15JzypZ8O9q/FdkDyo9Gen+CO95p2STRKf8KRydPex1LeA9p6HCrP3/i82VYpK1Bvzn3Gk3lVic7Y1FV4mnJubwwzmlaa+Ic8qRey2HpLXsiibV6w1eMm2APauc94hr8q08Y+43F3mruY6AvZsUaNgokWXWs0DxcNX6+wTzRy70/fmxeNRnf/mrOqpaNGyrlSvcO9L5RaHI1m+qiRGksmJaNG05StdgLedBJduKjCUaPW/RoGryU7RCPrgIaHKd0rmKf3LvjJ9jcKnmW7rLdse52G7HCe0FL0KOhRFG/1uAkn0aPIPFM2MmqUaVBTJ8/Zbv23GPtNXelDuNPv/M7XNVKb8VVyPFPfeYVdct5/tIWtVPWCbkrmNSP9oAkeaO4HU+7drXuybHLewley3AtZwUytcgrvgrUlX1C8j+ms16/pgw9f+oVs+Xpz8+aVvJDl5mtN/9U3qTODtVbdcTRShmbKR2vsKW+vzi+u09EouKxz09FIW+Lurzkryr56x6LR8d4XSqVPqEuKXmuUaHHJtUYy/l1r0zdjhYGuPJW1kYGjdDSKn/3SfygZ+wIG5wYTv5bMPRkv099IP8v2WO+s7Lw45c0lOePwkfjCL0CnR0GPIuk0exQnckJdpkESnHptn6SrXzRpnZTvfTbjvSn6b4Gd1IWf5bVSW1ctG+/zoaXdFHu97str/0XhxY9Vf5zdOVk2+aDJPRz9x+GSh3KyVbEVxG7umnq+IdWqpMyLQnqLgpcu/bVslxcyb1H+Jyh3+EJm72f3zn7E2v1aG7cN24hG3ijRgvPY3En7b++2luV+5qR8GegpRKODveasJvvqnYhGx3pfKJf4Goak6BipNybTuG/FlZVquuAb6uytq9177SWEX/YgQTTqkt9fF4YuyUWjyNcSDLNWUgd9gHSvQLSvQ/ACTKy/kX6W7bneSbi9/jumOqCR/Cj8+mLhScXzmuhR0KOIOc0exX34GoZha90TfIOf8qjcLFSNv2XRGjGNO6/dG9B+v6L0NAf3Kz5bY30CZC256ZzGmzaz3uk3Rir3Z0YWPFa9Uy3tDw+mmzpnsv47Srzp7YFM02hfPN8vwZjMvG2yVf7k7irCIWh7gi7RqsxnSuGM+rfla1sU3OvtWX1q0+oNtm6yX1OCG3PzZh4VsT3ZLz+5n5U1d03tvjMH5/cmT6tQjm/4mMxskEjmd41ur86vrq2fJCr+FSH3d4zmm4JxIe0qptjpyv006XsL+KfraK9mK7zm3L30q3fs3soaNTrS+0K56Jd3ZyTeJTMX9qR/18j7aSM1wARfAKv/NpEJ2uOlMvv8vXBGbZNjwx3OO2/fzHSvoNF+tqt/vnj/DC8KSj7LDrDe9PY6r6PKC2TqK4n7F7XdTrajR1HwhkSPwln+tnsUp/fl3QAAPACRn3yF4ii/2bNhy7c3+UOWiy60BO6zXX8cmWgEAMCRncQVXRsR/EzZPbdwe9NZ6gi/eAScpJ0/ZSEaAQAAAADRCPeCeqLvdBrq2q07vIe2vQAA3I2H9g770LY3i2gEAAAAAEQjAAAAACAaAQAAAIAQjQAAAABAiEYAAAAAIEQjoFTXDD9+fse/27jWeo/nFLfoFNucdv+26HjYV1C0Zv4Sr3v1yOia2vmGsgNs3L3dV5ilXydP6lV0zWj06foi9mNMppJqrFbEVNKKiEhr5tur8cbEvE0z/she68w4VcnXEjb1OH0tIiKd1O7s0xqbzrm3za13eKhUYlp/yZUp2IPzq83MtLEpTNPUJa9K08vi2CrrZdK0zhJbbw1t2CSnPel7/fvjmxJOsXC9vWWv0cPRcg/M9IicHkn2o8F7vFb2A2VehHWXkaYWr1XqejNNtR5IdtVKG+/0EZvYoulp1trTjCvzXhHsHWtaZT+7Rz917z5tTku/5gT3Gq1VB381y2xR+ihMam1n2hPv/CL7MI5+9nlkyvYi76GHeEUK38PU52JUV/bGeieUt7rFbeuaeuEeWLRsvT1dU+/2JdG3V+cB9wdv7SmuruNPGdun6wtnUdO/z8/Pr26dJd56a7gNm+S0J31v2im+sxfeq1rvPXR70ah1t3DcgNabxkhrlB1hgnntp5txl9M1ZZ2JTuo6uLG1DnEwgde/Ta23dR7ZstNvpkdebloThIfSV8n+BdZqR2useYP3jqAB6XeX3HtPa/oMFkzk3tY1tb9BiSX7dy1/PwseT/Pt7rO9tj8XCe51Hhyt8+Duuy1+q2LrjbMekPPTxH6UrvyIjWxRv/neM9Z61PlPeD9GBrvaX+mSF+XCNudkX3NMvK9+lFez2U5HoX97U/9pt8BYIaewWQ/t6OeeR972NbWyft5Dp0bu+IrUGu0jttONRiIiXnPCt8mMnVNK6bIPGo1GkY8Jbq/s7HF7dX5+XhKNponPL67tG+Z5b6+8TBM0IJjCX/qCTDQ40Xf2onujVnkP3Vw0Cj807/Or9zmgaUVa5ygOW+7e4u3EnTsT04zGDqyHelk3ztvewaJRa7zf6lrwCt6ayrT2S+pdRqPh7qD94YzBgnaKRtrHTvrHOXXkcwn7mJlwUCgejcKDrTwB4uuNOfYL6N6PWH2L+rbW1g7cUOd4+VEQkX1e1o/2ajbb4Sj4D+8+HdXSHSIaPaijn3seha8E4b7nPXRazm6vSMpbojdm4pxblujVd94t9meL4zLqpps/dhxus061MOO43vAva9WLHnpBc/x37+ipGe6JdP42e/eGO0nd3ty+0k/qWN6B1qPR7ZWdbaKTqW6vzq9ury/mOHT/o9GR3tkL741Y5T10Y9FI/WzJY02jvnkk9rz96rzo+Awr6qSuh7U7u7j44aist397sN66jjVqtEifI6w3ibuLRtanR9pL/P6jRovPl5iFfZNJU4tph/+66x3f/9XOWRt8nLtwvarDvYAe6RGrb1Hf1q6Zd9SmOsdLj8I4U/o1p/QTr+VLLmrcsqMQ2Yf9BAeJRg/n6OeeR+G7W/hE4z1UZI9XpOxIRWuc/n3X1Npbqv7+Gyx8nqpr6nG5TT2GDOftesxP8/QLBn7C5kxv3/65cmofoWwAp983ibnie2W9UaNF+vDy6fpiXMB9ikZ3+s5eeG98prt/D737aBT7iP7qVope1u3XU/tt1N7a+czC4EU/fY51TP/w6lfd/+28U2sngHoPx+h6x7fs1sx/HCgaift5zJJB9TE+TK+cdxaN7EUF5zz7Hy9pnz8lolHko7JDMep5tO6lRFrDnFOGD31ehnrOzOqP2Exbp9ezTXWOd5J9zUl3MY/xapaROAqxnKP2r5e26aEd/dzzSL3qsG6E99CDvSLluuP6mFIwyy7RaLxrfmN13u38yLLolL1w4rGF+bPU1ZbrvMk2Go3Efb6UjhgN813dipWu1o9GllN6Z9/PKu+h2xs1yr3ghtenxscfpI6cWbj0jbt/FNov7v7L+p5Jfby3v6j4cNHInWjRtUbW6H4/5r9PNHLvT9wbjq17n3F5M3oj7+klR0aNyk+oS9Nfq9KjRi7vQo5DiL6ArvqIzbV1HEzbs3Ocvuirvouvyln6iZd6QqXIIV/NMlJHITlq5N2yczR6IEc/9zxSR428fcB7qMger0iZ7xtQP2hTbjxONEq8gWaoo0am1c+XU85ei6aU4N35NKKRO9Gia43m4aLh6xX2iUbu/YbyqN4AACAASURBVOl7807pnX0/q7yHbiwajeclRQVvcPbBUx4r7vQ79yG6RmozPubGMzKtcfZl53dGW9hKVR8sGikv4eWnktlTtqaqm3Q0cu7VpiiNRpklKxuwJHQdZ7DIWnkyGmnCR4a+kEM3au1HbL6t/ULTnePsZV1b6hwXTjAdiOO9mmWkj0LiWiPbXtHoYRz93PMofIMPb+E91G/hwlekdDZaddTokNFovKXsTVBPKcG5d6cwaqQMzZSP1thT3l6dX1yno5FzrzbFpqKRtsSjvbPvZ5X30M1FIwne8vpP0lt3m627nZMvvc/cvV3j74hO6sKTLFqpravTjPdJ29KHo71e91D1X3J6qGjkjRItCAfupOM1lnZEse5XPnvbMRrl3oq05JQZVopHo66pD5uVCqNR18yTmeAkukN3eA/zAnroR2xRW2tvCNy9Lks5E+gUOsfBa07iZf1Yr2ZpJUdhmiA2zrlnNIqt9z4d/dzzyHtKqicz8h7aL3mPVyT/Yz3neqLgq4DUKBWNRs7XGLnXDt1hNHKap305U9mokdekoX/hL0jdXn/ZkWjkXWq18N05Fo28UaIF57G5k/bf3m0ty72KybokKbaqLUaju3ln388q76FbjEb+6ZLBV7ZX7ut4NX6jeWvENO689lHXvsW89Pxztz/QGuuLL6wlN53TeNNm1qv8akgw5JdsVeqnflpTmSb6lTIJ7u8YzTcF40LaJT+RXxByvpxHv9e6z3rbmFti1Hmt4aYd1nuoaOSdoWJ/BqsefjsaNY1+16EbpT4X7voRmzD/9Il1Bb/f7Y5clxXbz/006XuPJ/2aE7u3sj7xOtKrWULRUYj8rpHassLH8wM7+tnnUXjOm/9VciLCe+hBXpG808zC5KC83/SbkHlP8d5Jh08Y6+nGuunGhZh2/pa3xvtx1Nb7d3ovZ7/tzT+rzr432aPw7h17F+5npOH2etsQ2Vfe7AuCYPJ3jW6vzq+urZ8kKj5L3v0do/mmYFxIu4opeor+xfWn3L0FTuydfR/rvYeuGY0AAAAAYCOIRgAAAABANAIAAAAAotHDpH+Dp3ZeMgAA2ALeu4E7QDQCAAAAAKIRAODIqqrKTwQAwNqIRgCA4yIaAQBOAtEIAHBcRCMAwEkgGgEAjotoBAA4CUQjAND1P+Ke/Gn2Rb9Vf18Mv51eS/EWE42wr+WPOgDYwQrRqDVSVUqZVqSTOrg97G80tTuXe2MbTlkX7IlbU51XXplbEZHuurb/KZ+aeprmqhWR9sqf0Zm+b8mFdru9qKHq5pM3i3G2qL/xognW60ymLXmeMb296TZn90aB1ljNbq7r+rqL3dtKa4ZNm26vm0/2ek0b2ZzqvOqXvNeeXL5FVptTezJss73/7SaZW3fiqza9RWXHKH0UdPNTr39OWU/Y/ptjjf20te5tRaTVn/jDV86mn/vpedO6Rv/G27Lvuu2auiTzFE5WaGrycIDtTdjh4XlwQyfVaPfZh8qItP1kB4hGXVN2vO+Yvr0HsLnt1Z6Ed/lxQOpRBwAHs9KoUfD20Zo55Bg73rTuy28ntd0fcv9pKqlr695Wqlrqklxk6dQ+Yt8xvZjfqNqrypns1njBoL1yOqbzxN4/vW70rbHSUWvOTX1hTXxrqou6vnDfL29NddXOq5vWMk7mtOTCf6/Vtzfd5uzeSGlNEA+8JQfhYdw/QfubizlJ+nvS2bQ99mRWts2po68022uPfcOCLcoco+RRSOi0J5T9dA4maGqn+2TcDy+87l/quZ+bN97mph6na40VNjYcjUTmESv7hs0MTLV6MO0/92rdf97jaBTf3gPY4PaKSO0O2tR3mY4ijzoAOKjNRyP3rtYEL4zd/OJsKmnb+a2qNWKaw0Wjq7axeqLl0UiJDZ+a2s0/rTbjcNetmfrZ7VVlrv14MEx/a+x+8J7RKNPm7N5I8NrpNsCNOtN6DxONdtyTOek2546+0uxZLhqltih9jJJHIW16epqpl3KkaOQ+97PzRmWjkTes5B6NIfPM583p+SQWjaz5Fo74tKYybVPPq3OiUazNY6Aa7jbt1AJ73dFW3V6dR1x5nxfUlYRbUwcnO3XNEI3+z/91+rXTgH7nTWyNwMzHWxuv8I69M++42D6r1M0wImna+aQFu+2mctbrHoV5+unvadXx7R028J5tr7LJrbNR6pILW6VukUd91AHAQa0cjab3EZvdAepfLVvtrnlhZj6ZpxVp+oGjvoumfsidlIhGqS7v2Ivtrmu3O6t3fK3ZnQm669o6S2q4a+jg9sHAiwfWP50++l7RKNfm7N5IcccrbFrz0hNEolHY/j32ZFqmzdmjH51GpCAaJbYoc4ziRyFniDqd1OOQrBNRiqOR+lxOPPez80YtHDVqjTNW0zV1Xdd2frDjirsS5cYgkRT37Pq2WotIjBo5be6aesxvTT0mH2vVe7VqYoLhgmRUrapKmcDpZ7fO8fYGZNLLb43TmbYfOv3ffVPrsb/emvmNp6nF3Rv6e5KTQNrs9uoTnPT2KpswTtyvLrHkbKsSW6SuCwCO5vDRSOWvto1+aCXeB092NyuSc6Z3EGNd0mDMePHSAaNRfwXI+IcfjZTLOaJdZ7ePq10LNNw1XUhjTJ9w3AXarQ1S2biU5BliyvZm25zdGxn2JutxTpe8NMtdrB6N9tyTepMSbc4ffattoYJoFN2i/DGKHIWcPur0T7r+b2dsJ3e5oP3sVns++nO/YN4SczRKcFNT19TBVUnKYrRopK2tqAXOlFNySZ1Q5w2CWVFwmGXOQ/u1KuEA0Sh5hX1i+eroTT+xPdfUsZ4/k9MuDfIGK/sZw/1zgGh0UtsbW/Xw4UdyyZlWJbcIAO7WgaNRqcJRo9zFBsNU7qiRjCcvtHL4aDR93H6UUSPnQiPnruZi7O47vW03VimRYFjXsmhUOGqU2Bvl7Gtv7HPnYhPvN2ok++3JSPsTU+4yajRvVEk0im3RomOkXAGV2CQxrROQ/Gh0kFGj4Lmfnbes8WoEcM8vq4JRoyCQhLcpk+339Q9WW4dw5EajeJvT0SjdqvIT6kLqq/moIBpZZ3Cpl/hH+8rqNx9Y7zGJTrlzElf87DX1AZfcXr3BJ7296iZME6eXvENgO+AXWgDAEitHI5V/KbbV08pfayTBvQeORsN1GtlrjeY2L7rWyLkIROtY693f+Lp2iUZF1xrZDS6PRkpjrKU1F8mzvBZea2Sv9iB7UpVu8w7XGiWiUew8zMwWBccofRTSukZqMz6tWqmMG34WXmvkSTz3s/OWiIyYuDceddRot7a2pqobKxol27zDqNGh1NEjVBSNHO75ZnKHoyih2CMvvr16g099e9VVD7ckl8yoEYDTsfloFMQhY5+DF3xD3V1Eo/Fbkguj0TAiMd2b/oa6Jd1f/QsAgjO4dohGmTZn90Zce+WfvuU2rzXuvc7FV0uj0aemnkdO9t6TwwfqF9f+uWfJNmeOvtI2qzHuFUHOCNWysOcdo9xRSGqd74E03ultS6NRJ7WJ3hs+9xPzFrU9fzJZa8JRo9pJR+XXGvXRxJts+ajRsNKqsqNRvM2ZaLRfq3KN9k8Sa+r5G+q6xrq39a+2965UkSB4OKM07XBB/7hFQQixrr1Jd8rDeZu6eBQlur3jWu7Z9gYZxn56J5a8Q6vSsRMAjmaFaOSdROB+9mldqODmHztKKb9rpM1oT5ZX8LtG3g/FuB3N6K8DDY3J/q6R23uuLurwLnsh4eVJ/i/hhCeJ2eFt7981iu2NtOGL1GKt8vbJufpDTN7vGgU/++MtXNvJ5XvS2mOxaBRvc3JPRtscvYBqvD2zRbW5yj9iM0chdQj9Tto8tmNdQ+j9rpFpnXud6p+w6ed+et6CRvunnyW+r234djfTjvfUTWefhmZHoGC5/sL989eKvzHcX5j15QqpNrfOL9AO/xq+zmFu+26tKuKdWDUuuepfhe0X5VaGQz5dxJ+4Rq1nT+Pd683e3zu/2dTSjTnetGMjx16+N6//UVzy3LPI9iqtOvntLfjePHXJu7WKr1sAsJKVRo0AAA9GVfQBFQAAKyMaAQCOi2gEADgJRCMAwHERjQAAJ4FohEMKfncodQUO8GDp36B98Ct/NoNoBAA4CUQjAMBxEY0AACdhn2gEAAAAAPcE0QgAAAAAiEYAAAAAQDQCAAAAACEaAQAAAIAQjQAAAABAiEYAAAAAIEQjAAAAABCiEQAAAAAI0QgAAAAAhGgEAAAAAEI0AgAAAAAhGgEAAACAEI0AAAAAQIhGAAAAACBEIwAAAAAQohEAAAAACNEIAAAAAIRoBAAAAABCNAIAAAAAIRoBAAAAgBCNAAAAAECIRgAAAAAgRCMAAAAAEKIRAAAAAAjRCAAAAACEaAQAAAAAQjQCAAAAACEaAQAAAIAQjQAAAABAiEYAAAAAIEQjAAAAABCiEQAAAAAI0QgAAAAAhGgEAAAAAEI0AgAAAAAhGgEAAACAEI0AAAAAQIhGAAAAACBEIwAAAAAQohEAAAAACNEIAAAAAIRoBAAAAABCNAIAAAAAIRoBAAAAgBCNAAAAAECIRgAAAAAgRCMAAAAAEKIRAAAAAAjRCAAAAACEaAQAAAAAQjQCAAAAACEaAQAAAIAQjQAAAABAiEYAAAAAIEQjAAAAABCiEQAAAAAI0QgAAAAAhGgEAAAAAEI0AgAAAAAhGgEAAACAEI0AAAAAQIhGAAAAACBEIwAAAAAQohEAAAAACNEIAAAAAIRoBAAAAABCNAIAAAAAIRoBAAAAgBCNAAAAAECIRgAAAAAgRCMAAAAAEKIRAAAAAAjRCAAAAACEaAQAAAAAQjQCAAAAACEaAQAAAIAQjQAAAABAiEYAAAAAIEQjAAAAABCiEQAAAAAI0QgAAAAAhGgEAAAAAEI0AgAAAAAhGgEAAACAEI0AAAAAQIhGAAAAACBEIwAAAAAQohEAAAAACNEIAAAAAIRoBAAAAABCNAIAAAAAIRoBAAAAgBCNAAAAAECIRgAAAAAgRCMAAAAAEKIRAAAAAAjRCAAAAACEaAQAAAAAQjQCAAAAACEaAQAAAIAQjQAAAABAiEYAAAAAIEQjAAAAABCiEQAAAAAI0QgAAAAAhGgEAAAAAEI0AgAAAAAhGgEAAACAEI0AAAAAQIhGAAAAACBEIwAAAAAQohEAAAAACNEIAAAAAIRoBAAAAABCNAIAAAAAIRoBAAAAgBCNAAAAAECIRgAAAAAgRCMAAAAAEKIRAAAAAAjRCAAAAACEaAQAAAAAQjQCAAAAACEaAQAAAIAQjQAAAABAiEYAAAAAIEQjAAAAABCiEQAAAAAI0QgAAAAAhGgEAAAAAEI0AgAAAAAhGgEAAACAEI0AAAAAQIhGAAAAACBEIwAAAAAQohEAAAAACNEIAAAAAIRoBAAAAABCNAIAAAAAIRoBAAAAgBCNAAAAAECIRgAAAAAgRCMAAAAAEKIRAAAAAAjRCAAAAACEaAQAAAAAQjQCAAAAACEaAQAAAIAQjQAAAABAiEYAAAAAIEQjAAAAABCiEQAAAAAI0QgAAAAAhGgEAAAAAEI0AgAAAAAhGgEAAACAEI0AAAAAQIhGAAAAACBLo9EXX3yxc5SiKIqiKIqiKOp+VJ8LROQ+/bf6pXj85/z8fNoFAAAAAB6mPhfI2knm4P+tpr+yZUejdUMqRVEURVEURVFrlZcL7s1/iUYURVEURVEURS2oBzdqVFX+ZUhEI4qiKIqiKIqiHtaoUVVVRCOKoiiKoiiKosJ6QKNG1UjdBeH0FEVRFEVRFEU9nHooo0aVJb0LKIqiKIqiKIp6gMWoEdGIoiiKoiiKoqgHM2rUF9GIoiiKoiiKoii1HtCoUV9EI4qiKIqiKIqiwnpYo0Ylu4CiKIqiKIqiqAdYD27UKLYLyqenKIqiKIqiKOr+FaNGRCOKoiiKoiiKou71qNF5sT4alU8PAAAA4P65n6NGXwAAAADAQqsnmcOPGq0dOAEAAABgff43dFMURVEURVEURT3AIhpRFEVRFEVRFEURjSiKoiiKoiiKoohGFEVRFEVRFEVRv0w/+XqfrL5PKYqiKIqiKIo6uaruX5b44osvVm8DRVEURVEURVGnVffwhLrz8/O1B67u1Oo7nKIoiqIoiqLuQd3PaPSgBo4e1MZSFEVRFEVR1JEqGo3M5Y1aT41fq2+DV2o0+vnnn3/++ee3ru+//8vqrT3I9jJ2RFEURVEURVF7VioaXd7IUJdiInUq0ejy8sY7D+3jx4/m8nL11h5peymKoiiKoiiKWlQLRo3C8aKn5ubp00g0+unFk8rx/PVOTfzpxZPHL9ols6Sj0efPn2/+Izf/kb/+8w9jiEYURVEURVEURf3jl0Q0sodZ3r17N/39888/93/897//vby8efrU6EvwIs3yhOPMuGT2RDT69ddfb25u3r1799d//nF5eUM0oiiKoiiKoiiqr6JoNMUhEXn79m2fiz5//nx5efOnP/1JX4IfZl49r55d7NDEw0Wjy5ubt2/fXl7efP/9X/paEI36QbCzV+MtP758XFW7hb1DF9GIoiiKoiiKovavaDT6/vu//Prrr+/evfvZ1aeL/jsMFkSj6Z/ziXaPXv70j1/e/6P9+lH/7ydf/+jMNYeiZ88fV1U1RBFnem3Vhdca/fWffwzDRzc3lzc3v/32W2pP/fTiyeNHTtsqohFFURRFURRF3Z9KRSN11Ojy8ubz58/9FTvff/+XVDRyLjXqh4x+fPl4SERjChpHk3568aR6dqFHI3vUyJ1eW3UsGv373//++PHjx48fb27kr//846///MPeqKdPTSod/fTiyeMXL8/Gxr9+9uTs2Y6nCB66iEYURVEURVEUtX8tO6Huv//979u3b6dvMshEozk5/PjycfX8dZiXHr386ceXj60hoHw0cqfXKhaNfvvtN2fs6+amT0VyaS4vb969e5dKR30DXj/r13tx9ujl67JxsOCfF2fBV1PYu6VsmdntpSiKoiiKoihqUUWj0Zs3b25ubvogMV2l0/93ulzn8vKy9IS618+qs1eJoZ6Ls6oqGjVyp9cWVXhC3RCNRETkt99+e2rM06cm860S00jX/HduHCwxzDUvwcpIRcvMby9FURRFURRFUYsqFY3s88367134/Pnz99//5eY/0p+T9ubNm9JvqBs6924M6LPQMDDS5wHr2xpeP6vCaORPr6w6EY368a6PHz/e/GeMRpdGjBERc/n08vLmqUlvzo8vHz+7mGJe37D0OFg4zOWNEalpMLPM/PZSFEVRFEVRFLWoiqJRfxLddH3RdK3Okmg0haJXz8tOP6v6rz2Yh02GYaJ9vobh8+fPfS66+Y/Y40ifP3/+7bffLm/y30Xefv3oyeNHw8mBQ4xJjoP5/3z1vHJHhPRoVLTMxPZSFEVRFEVRFLWoUtFo+j46+yS6/ovp3oyiWWK9SkSjKRfd3IzRyBgxT//973+by6cl0Wg+pU09HS4cB3udGxbTT6hLj63lt5eiKIqiKIqiqEWVikZ/+tOfnj413n/tP3qrb4NX+Wh0I+bm6fQVfB8/fvz1119//vnnBb9g69xSOg7mD4spX7owfSF4ZpnZ7aUoiqIoiqIoalFFo9HpViwavXv3rv/h176GaGSeinn67t27p+ZpKhrdTfVXMR1ieymKoiiKoiiKWlQPKBo9NeZ//ud/nhrTVx+Nhp98Hc8YXCMaTQNE8xjR/ttLURRFURRFUdSieijRKKw+CIW1evuPtL0URVEURVEURSXq4Uaje1MPbXspiqIoiqIo6hh1b6ORAAAAAECxexiNKIqiKIqiKIqiltYcjc4BAAAA4KFyotEXAAAAAPAg+dHoeKfuHXXhuGMczQR2zhZwFAAAwFJKNDrGeXt27lr9JEJqz+JosnM2Xsf+oAcAANxLRCNqcXE02TkbL6IRAADYAdGIWlwcTXbOxotoBAAAdrByNLo4q3xnr/zZf3rx5PGLNn2LfVf16OVPBVNSu1ai999+/Wg6ks9fRw7Q/kdkw0c5unN+evHEepjrOydXRc8XimgEAAB2spFRo1fPq2cXsdkXR6Oqmu7dUqf53lTsaLZfP5r3/PtXz9UAcLBotNGjnIpGcyN/fPl4n+iYfL5QRCMAALCT+xiNHr94eTb2O7fUab43FTmaP758bI3kxOpQ0WirR7ksGsXbTDQ69FEAAAAotMVoZJ819Px131l89vxxf8Ozi/dW93E+SWnslPd32RM8ftEml/nk61cvhz9+/EVdJlVyNBN9/So4dvbE8y3aERlTkHMe2oaPcmk0Gh/zbpt/7BtZqZsTzPtLP814Tt3FWfXk7Jn/ZDnmxm62iEYAAGAHW4xGfm/ypxdPxq5h+/Wj6uzV2Mu0him0XvLYOdZGnKaLVew/YsukSo6mvrvmM8ecY6dGI/WIWEf/JI5ycTQKBtnCPROd13q+/PTiyfD3q+fVswvrKqxhhz/IhzTRCAAA7GCT0ci+YD3sRvf9v7HTbLH7vv/45f2r597AgrpM7w91mWv387ZWC6KRPjoUGzWKHJHwmqINH+Wlo0a5R7t1Vzjv+3/8MuXD18+sTw2m2fuw9OAe0kQjAACwgw1Go1fPY2fHvQ+61+FYkzVx+/WjJ2fPnjx+0SaWqXSauYpjt6OpXWt09Gi0uaO88FqjxKM9uGtemvtRwutn1dmrizPvo4EH/ZAmGgEAgB1sMxqNf79+Vrl9u+CEOutUK+8ypGFR/cft2jLVTrO6TKrsaGrfUBc5oa78iOSi0daO8sJvqIu3ObxrXpp3Auq0B5zNsU6oe3APaaIRAADYwQajkfPbOGM0ck8rcrqP7mlC7ufrU2ddWabeadaWSRUfTeV3jabD5+7necrHj/YZNdraUV76u0Z+m4eGPbtQ7pqW5l+bd3Fmfb3E40dP/Fke3EOaaAQAAHawkWhEnVJxNDe2c9xvZXgYX7RQfhQAAAAKEY2oxcXR3NDOef2smr6R/D3RSDkKAAAAhYhG1OLiaLJzNl5EIwAAsAMlGp0fx9RTOdLycZc4mgnsnC0gGgEAgKX8aHRUInLsVeDOcDQT2DlbsPKLKwAAODV+NDr2iS5VVfHfe/Nfitpyrf3qCgAATowSjY60pn7h/8J9UVXVkR4q9wD98tVxCAAAwFJ6NDr4x7fTwquqWrtLj8Og65nAzlkdhwAAACx119Fo7f48DoZRowT65avjEAAAgKUYNcKO6HomsHNWxyEAAABLlUejV8+rZxfHHjX625+fPPnz3/r/Lumm/+3PT6rR2Zs9+vt7WL8NdguO34bEqFHX1FMzTHuHD2e7BXXTeU25w8ZE++VdU1d9y9x2qjvNulf5Z2sqb1GVw9rY1lSmldbMd9ZN199Y2jxr7nkCe4nKLo4uzVv1+E9vA9VbihGNAADAUiXR6MeXj/tezwGiUWbUaKdo9Lc/P6nm6d+claSC5elr+21wF/i3Pz85bjqKdT3d/nBrSgLJHj3gzAKdJXdNfUfpKBmNrHAxNk/faclo1JrKGONsXGTirqlNK0EgUW6INc85jF7g0ReUXBrRCAAAbNI9GDXaKWEcOJZsoQ3BAg++fFdk1GinzuwdRaMjrCgiFY3qpjHeuFCkWanG93mnNUrw6E3xIx48ptC0tHl+FIpHI2Vp4fREIwAAsAl3HY30USP7TLAhGp2dPXHPC5unccdC1ABg3zj+PS3gyZ/fDH/203hLttY+TTksbJ5yXOLUzvXbcPbG3xVvzqalRZodX3h+wEnveqp9WftGe5xkOD2rHf70T4GbusvG1M6Uw8LmKcclDlOaNhaNYp34Q0tHo85rXiwAJKLREGrcsSF14mmLrTPu7LPknN0Ra14VJCg125RsrDI90QgAAGzCFkaNrFO/3pwN0Wjsm4/3zdP4J4qVRiM7J9gpIljydG6c/ceTP//NXug0uuVMsGoblF0RjMGFzfYXHtnJGn3UqDQaWb1hO8lYne7hr+n0LfsPbyhj7sEHOcFvzx0NG2Wi0ZQGstHIu5LHP0dO3D1n04ZqtJ2s7p5c8yLZpmRjE7MTjQAAwKo2MGoURgjvFm88pOS0MWX6v/nDI9NwTWzt3h/ulxwMIy7hQtZqg9KMN2f9rss2W93tuZPx9hs16vzxnzDJxMYc5iDkhoZWGZva6KhR35Jp6xaPGrkbn7yqKn1A4snRbd4+o0be0pTpiUYAAGATNjBqlI1GmV671ouPT//mzD33bFksiZ3Lt4U2REJjYpb9opE+aqR2ZrUT6nqtiZ//lo9GynUymWi0jWuN5pEtY3a51si5RMg6Q9GeOHGFUdmgWqp5S641CpYWrDbaGqIRAAC4UxsYNfLO43J78/kT6vRvhxtPXfuXfZKelQPe2KkmOJlNTQ7/Cprlnqq2ehvcPDNNGZ8lvvCSE+piXc9O+bI1q+vcn9Y1T9Q1tT3go51Qp0Yje+TCPysv1tsO49SxlESjIRi6ZwtOtye+oU6/OTY+5p66ON6lD9/Emrf7N9SpS/NmsK+GIhoBAID1bGDU6F/2txM88U8bc86sc2/515w97Dnmzr29TH8Bb86mab0lR5PDv8a5qkq7xGj9NrjnzlnRJjKL+oe/k6Mio0Yi7vle/lcA1HXwNQzd+AM5UxdeO09MSTvTz+oEicGe2Nonm/hdI3e8xL58yG+nnoHmYGMtxU2G861ixxB3f4k3/JRunvq7RqOSaORFKmtz7aNmHazxSrMdjx/RCAAALFUejfaq0t81wumg65mwqZ0TBKDRHV14tY5NHQIAAHAS7joard2fx8EkRo2wsX65moHudTDa3CEAAAAngFEj7IiuZwI7Z3UcAgAAsJQejc6PgFGje4ZRowT65avjEAAAgKWUaPTF0TBqdJ/Q9Uxg56yOQwAAAJZSotGxq6oq/ntv/ktRm621X10BAMCJ0U+oO4ajLhx3j6OZwM5ZHYcAAAAsdddfw7D29uJgnkrCFwAAB9RJREFUOJoJ7JzVcQgAAMBSRCPsiKOZwM5ZHYcAAAAsRTTCjjiaCeyc1XEIAADAUkXR6OKsGpy9Om406pq6brr+v0s2o2vqsYmr/Yzl+m2wW3D8NiSO5uq7ojWVb7d2TA/Fhfs2unO6pq6sB7f1UFd2mvdE8P7ZmspbVHSL7V93dX7pdd5RptV/BDbeYGvmeYLMno8uzVv1+M/wpaD4xYFoBAAAlspHo/brR2Mi+vHl4+r5681FI7e71ZqSbvDy9LX9NrgL7Jr6uLEkdjQ3sSvmte+3D+xotGTfJqORFSXGxeo7LRmNWlMZY5xGRSbumnrMGW5YmacZ/wp3WKTBzoH1As/YOmUPxZZGNAIAABuw7IS69utHT77+cWPRaKdu9YH74ltoQ26Q4dAiR3Mbu2JwpGiUb3AqGtVNY7xxocjiUivt805rlJjRm7Y9kjr0P8cYtbTB/p6ORyNlafFGEo0AAFjF3/8uVZWZpqrk739fsMyl069hUTQ62qiRfS7QEI2MCT/hVs9mUrtK9o32B/PDGtrhT/9cqak3Nqx9mnL+bN0+g8hu5/ptMG2scxxvdnzh+UShH81NHA7l5DF7kKM1VW1M8jFmDbio0SgXutLRqPMWG+vuJ6LREGHcsSF14nho0Q5LMHmsweHTMBbAspuvTE80AgBgVUSjbDRqv35UPX7RHv5aI6tX1ZohGo3d1fG+eRq/D1baF7dzgp0igiVPZwfZf3iflM8dRHuCVdug7Iqg3x022194ZCdr9otGR94VA6vDPS+4Nf0aK2+VWsyIRqNMDz0TjaaWZaORd92Of46cuHvOpl+vlI1GsQ3NNTg+NpXd/MTsRCMAAFZBNEpHo31yUSYahR007xZvPCTxUXpimWPPce5Hhj3B2Efac8/b7aW2se7kGm1QmjFlgFyz1d2e64DuF42OvCvsPeD9o/+f+hgLU0g0Mew3atQvYdq6RDTSH+puW5UWOgnzINHIb/A+o0be0pTpiUYAAKyKaJSIRnvmon2jUabXrvWV4tO3pnLOPVvWF4+dy7eFNkR60olZjhGNNrIr5sX739M2XJ2jrkj9fjY1MeT2T0E0kq6pa2PGoKgtLrbSzr4gaLzVmzgaLtLXGqWeXqkGL7nWKFhasNpoUCMaAQD289138t13w98fPkhVye+/D/98+1a+/fYAE9g+fJBvvpGqGmry9u1wy7QocZODnUyqSn74Qb76Sr78crjlhx+kquTLL+X9e2eZX37pLzMxcdgAEfn2W6kq+fbbYYL0wqtK3r4dlv/VV/LhQ35D+l3Ur+KPP0RV3uBwgf3fdmMWKohGr59V1bOLPXJR+Ql1XX+Wk9VJ7ZrcCXXTXMO/+otK3E5fbZ9t1TW1PcIQLDnWF5egWW4/b/U2RMYN4rPEF67GBE+s67mJXTGv3RuLsK9oij7GnJ2XHJNZunPc5czt0XZaNBrpN/ubP257IrRo2V6/1ijcgTt/Q526NH2Aj2gEADi09+/ngPG//ztkgN4338j//u8BJrB9+aWfPUTk7Vv56iv54w/54w/56iv54Yfh9kSiqCr58GHIEn1K6f/+5pt5+n6ZIs4y1YljDegDmIh8+DAEofTC+wDTJ8OvvpqXn9gQe/pwzyxtcL/ADx/k99+jjVkoH43mHzWqqqqqjvINdd10SX7tnytl9/u9W9xTg7xrLOZb+mX6C+h/f8X9lgK9C+71G7WzrTbSBrsF/s/aJE8Ss//wd3JUouu5/q4IHiHTv60sUGuPKPemcM/4+3bhzgkfM3a69pavZ6B5I6ylhMlwym+pq4Dc3zUSb0Aq3WD1d43UtRQtzd4BkYf0eO1Z0ZEgGgEAdNM4z7ffyu+/D33oP/6Qqhp65PtPMOn76N6NX345p6k+CUwNSwy2qLPbK5rmtZepThxrgH273YDYwu2GeQ3Obsjf/z4vJ9a2bIPtBcYas9CyL+8+zqgRTtIJHk11wOQoNrVzgrgTt/e3nW/Hpg4BAGBDvvtu6EP3IyT9cMT79/M4w/4TTD58kO++k6qSb74pOt8se3v4z+lGu9S4pS6hsAHZhS/dkFh62bnBJQsvQDTCjk7saDpnbz2saFSceO5RMNrcIQAAbMb79/LVV/L778N5WT/8IO/fy3ffzefC7T9B6Jtv9MGZ/lSxXmE0io2rqN9wUDIIMzXAXoh9rVFs4ftEI3vwZ+cGE42wHRzNBHbO6jgEAICo/mr+/ir///f/5Lvv5utb9p/gyy/ni2Em/QS9/pKe6cqZqUP/zTfDtzj8/rtzqY8XjabZ+8X2+sAwfSFEeuJYA777bkgdXgNiC4+lkcSG9JcGiXvNkr3HFjX4zqLR+REQje4ZjmYCO2d1HAIAQFR/ktsUdfrvNzvUBHZHfzoJzT6hbprdu4jowwf56ivlC+LCc8z62b3BnOlL5Cr32/DUidUGTN/w9u23frpQFx5LI4kN+eGHeRUTL0yWN/huotEXR0Nn5T7haCawc1bHIQAAAEsp0YiiKOrUa+2XVgAAcHr8aLR2ewAAAABgBUQjAAAAACAaAQAAAADRCAAAAACEaAQAAAAAQjQCAAAAACEaAQAAAIAQjQAAAABAiEYAAAAAIEQjAAAAABCiEQAAAAAI0QgAAAAAhGgEAAAAAEI0AgAAAAAhGgEAAACAEI0AAAAAQIhGAAAAACAi/x/cE1lfbNu5HAAAAABJRU5ErkJggg==)
Conclusion:
So, In this tutorial we have learned, Sql query Script to get the columns with datatype of tables with default values