Category >
MSSQLSERVER
|| Published on :
Sunday, August 17, 2014 || Views:
8272
||
Get tables columns with increment value with SQL Increment value of table increment value list of Get tables columns with increment value with SQL
Introduction:-
Here Pawan Kumar has explained, Get tables columns with increment value with SQL Snippet.
Description:-
In previous post I explained How can we copy data From one Table to another Table in MS-SQL Server, Get todays Day Name SQL server, how can we convert negative a number to positive number in SQL Server 2005/2008.
article I will explain you how to get increment value colums of all the databse tables. In real world, the databases are very huge and it is very difficult to identify which table and which column has the increment value and what is current value of that particular column.
To get the right result, we can use the following SQL Query which can help us to get increment value colums of all the databse tables
You can use following script which will return with the table and column details who has having increment values.
SELECT OBJECT_NAME(OBJECT_ID) AS TABLENAME,
NAME AS COLUMNNAME,
SEED_VALUE,
INCREMENT_VALUE,
LAST_VALUE,
IS_NOT_FOR_REPLICATION
FROM SYS.IDENTITY_COLUMNS
ORDER BY 2
See the output:-
![get-tables-columns-with-increment-value-with-sql](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAxUAAAE/CAIAAAC/13kkAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAgAElEQVR42u2dXW/cRprv+wtJEKCr9JW/ggDpxjdz19ejGWiFzE0czAS5CAIpA8GCJzEgYBfeHEAJMLZBTDI4GHuwAWxLyBnYEwRexRPH2SQbwU6cxDac8dnTp9hskkXWC6vZLJJN/v54YLfYfKsX1vPrp4pVgzFCCCGEEJpFA7IAIYQQQgh+QgghhBCCnxBCCCGEFpqf/h9CCCGEUEdVGT9pz/4/CCGEEEIdkjtODVzIKTrp/0UIIYQQ6o1kqHLlp4ScolO8ePHin7F+RgghhBDqqBLgEfCTgFSOogaF8BSR0/Pnz589e/b06dMnT578hBBCCCHUUQnUEcAjsEfAT0JROYQy8lMETxE5ibOI0z1+/PjRo0cPHz48jfUtQgghhFAnlOCNQB0BPAJ7BPwIBIooKkEoIz/J8PTFP+6eO3fu73+7Ef1bznjLESGEEEILpAcPHnz11VeCpb7//ntBUSpCDUw9dy9evBB7w08IIYQQ6ptu37599+7d+/fvf/PNN999912EUAKNkl48DT8lwaenT5+W5qczZ86U5i0MwzAMw7AG7fr16zdv3rxz5869e/cEQn3//fcCiuQQ1MASfPrxxx9z/ORIbWLniJ8AWIQQQggtnN57770PPvjgo48+un379v37909PTwUUySEoDT9Fwadnz549fvxY5ScXapP5CYbFMAzDMGyx7J133nn33XcFQt28efPu3btff/21gCKBRlEISsNPcufdo0eP4CcMwzAMw/pmb775pkCo999//9q1a3fu3Hnw4IGAIrkLz8hPT548efjwoQs/DQYD+AnDMAzDsM7Yq6+++tZbb126dOnDDz/8+OOPP//8cwFFAo2K+emnn346PT0t5KfBRPAThmEYhmGdsZdffvmNN944ODgIguDo6OjevXsCigQaFfDTzz//7MJPg1jwE4ZhGIZhnbGtra3XX3/94sWLV69evXXr1meffRbxkwCkYn769ttvLfw0kAQ/YRiGYRjWGfvVr3712muvvf3225cvX75586bgJwFF1fAT8ScMwzAMwzppm5ubv/3tbyN+unHjxsnJSZX8xPgnDMMwDMO6Z7/85S8FP/3hD3/44x//6IWf/s77dxiGYRiGwU+z8pNq8BOGYRiGYfAT/IRhGIZhGPwEP2EYhmEYhtXAT+ecFfHTOYQQQgihRVOV/HQGIYQQQqgHqpKfEEIIIYSIP83ATxiGYRiGYYx/gp8wDMMwDMPgJwzDMAzDMPgJwzAMwzBssflp3C1RPzAMwzAM88tP3QOOaJIqDMMwDMMwL/zUyWiNSNq4T+J5wDAMwzD4qQJ+6lUIingbhmEYhrWFn0YXjrW2OsrbQvDTtYkuZ3Vw8G+dibfxVGAYhmFYK/jpwvF4ahfGI4MtCj9dEMnI6vT0dHThAvE2DMMwDIOfPMaf1MhTaKsGfrqyuTLIaGOvVGrFeZY3g+r46Ycffjh+OBZ26dbj0Qh+wjAMwzD4qTp+kgM2R0dHyedr165FH54/fy72WV0dOXHP7BiUOXCWwy389Omnnx4fH4vkCHgSW+AnDMMwDIOffPFTwkxCly9fjuDphx9+EPu89NJLbnGjnY3B2n6j/HTh+FjcvPhwcPBvkc3AT1E4bX0n3nK4vTwYlCNC+AnDMAzDuspPAi8+/fTTo6Oja1lFCBINvp6Bn5I/0369pe0r4VfB1lL098rWYeaolJzWNpYne0y+yuw/x/inS7ceTwNRxyFa3bt3rwjjljL3NoCfMAzDMAx+UvhJG38SIPLDRMcPx2IfGz9lhj9FwafD7eUpNsWoFMelwv3X9vX8JMefsvvPwk9ffvnl6UTHxyE8CZMTtbo6siHU5Aa21+Ob31tbWV9bgZ8wDMMwDH4q7L97/vz55cuXkyHYBfyU4kXY2xWOH89DlcCRSUdYEkwq5qfs/rPwk8CjTBTt+DhCp/GFkfj26OjIhlDRDQhsmlx3X4DUnltETflzf10ZUy9ni9s54ScMwzAMayM/nT9//vj4OKKNZORQ9G8yhOjChQuu/Xd7a+HgIXPQaEIVLvGn7P5z9N9N+WkigU2ro5Hgp4Lh8EnMLP1cFFGzBMzSM0gg5XRO+AnDMAzD2spPcvdWNGBcSGBTGHyadIGJfVzfv5sSQJYVImCahlgiaJCGmQvkUvkpv/9s/BRFzsIuvIcxP10YjUcj8f/owmrYizeyJ0dcdG0/YcHoxuwRNTVglos2aZGx4JzwE4ZhGIa1np+iPrtkzFMyfmgWfkrISRCSU2/XIBqvnQZgpgGnecaPiyRE8BTykxSREtvv3bsniKowOeLqK8tL077IKetYI2r5P0VCsrElPT85nRN+wjAMw7DW8VPytp3cZxe9dnc+lhE4WjaeOqKlBJ6Oj2N+Go3Go9Uvv/wyjD858FPag6btfVMjantFATZ9/509Sgc/YRiGYVhb+emll14SPJH7V/4QafH46Xg8Ol5NXjAUGz/99NNwmJf7dKCZLa4RtXyATTNaPJkToeCc8BOGYRiGtZGfFtdM/HR0dBTNohnZlJ9Gq8LCl+9GqzZ+qseikVVVpBfDMAzDMPipAn5aHY1+8YtfhO/ZTSzip+n8mXEHZRP8lISa0mgT/IRhGIZh8FPz/KRaREuqdTW9GIZhGAY/wU/wBPyEYRiGYfBTpTwxRgghhBCSBD9hGIZhGIa1IP50DiGEEEKou/LFT2cQQgghhDoqj/zkr9ORMUl9EyVOnpB88pmEo1aVsl9+8j2mm/7X/rwVSImTJySffCbhWHveD4OfMNoy8oTkY+QzCYef4CeMtow8IfkY+UzCMfjJpWbvrw/yShaA21vLrGciL7KbbNcu65s938ZetDF7Kvko7YXSdegOt5d1C/0mJ6dOz9iWySsopxkYloKyiI1avuFyN2v76p8FpaY7Z+21wta+SyeZHm6syQUbzXUyXCko8214YJyZanpnyvl5ku9QIpo6Y7quJYvci89wJ7b2aoHyOWe5W9LVxu4kXH3QVLO0DLpmyi1z8gmZrgRvavccHU2Jp0DdU/WhludOV5r6HCjKt4IWGH5y/mWQe3KmRbKxvjatZLlHUW5wzWWfr2TyIyTto7nQ8lL+eTNdDpuxxMMHMs3DuMENny6pcC18bGlkLaWmLf3aa4X5KRCpkJKcpkhXkws2hmRgam1F5qcpyv6pS697zs+X/KIS0deZ3HUtbUKJ4rPWDW17tUj5bG9ptbWxIwm3JM2h9E3NlFvmaBLi2O5ZcmDmp0DXDBp8qP6509cZXQ4U5lvBUwY/lecn4QbElp2NTJOX7GN+tMz1ZntdS9y6C4U7x2W8t7YiKgr8VE2Ji9xW10hWNornLfoBN2Mjayk1TenXXitmc2ylN7q2tnK269PbAD9pSkRbZ8xMY2sBnIvPVjdm9ZTty+fCltZ4oQVPuOOpHOth0kyV5Cf3ds985tmfgsDVhxqeO21p2vipIJnmpwx+Ks1PIivDLJayfs74k9ioPUp7IfHt3hSu90Wbu7cJP1VT4sbf+krpG1sBayNrKTW19GuvFeanIAwa5X/MlYcqSzuupMie3kbcm+nP+X95uxefpW64eMqW57O9pdXWxo4k3JK0otK3NFPl+Mm93Wsk/mS/aL7OmPmpMJkz0i38VPxYBltLEZOmEeCS458y1XF/PR/5118oLdQJYuf6F3Inx+bnJ1NLOmsjayo1benXXiusT8FkRE6ubmtrsrl6W4N8+S4VuW/FmN4yw1NmT769RCz8pL2uJYvci89cN9wwot35bG9ptbWxOwk3JU2zf1E9NNzw31zGKq3t29s9R0cz61Pg6EOt/GSoM2Z+KmreDU8Z/FSSn5IqPlHazM3Vfzft/86UqOFC06jj2n4UabxC/GlB4k8FpabnqtpqhdP7QeLkjr8gy8SftEF1S3qb6l6RSsQp/iSN+rJlkXPxGeuGK0a0Op/tLa22NnYt4WrSikq/sfiTbURjqaegaGMBP1nqTKn4k/Epg5/K8dM0PJj9MZ0pBmnjbPw0QWZ56IP2QvHouZXlJW3EAjxqbvxTdmelaOylli/9emuF2/vV7iMYZh//lKRoT+1bKXqyinK+2uEpUom4jX+y1ZnZi89UN9wxos35bG9p5wmxLErCnQcV2ephbeOf8hea9ylw4ifLc2esM2XGP5mfMvipFD/pX+LIjX8qGX+avkcwSBpT7YVyES/4qUXv38XBXtOjWFBqaenXXytseSJP2zFX/Mn6azVJ0XKmb8WWXvecr3h4b6ZEit+/c+ROx+Iz1ZkZMKLF+WxtafW1sRMJtybNofSbev/Oy/jxQn7SP3eWVyzLvH9ne8rgpzL8JL1iKtOSae4Kdc6J7DwU6rMaVwvzhUxMpj05tOR1/ifNrCpSANnyOo/BQaaNQu21wpIn0gQqphEMcU0u2lg8J1mm6Xd63Apyfs7kF5aUaf6n/K95/RRZem9tLz7znbhjRBvzOXOtNf0taWvjoic8Pps5aUakyJS+tpkqzU+u896ZfxTN+RSYfKjxudsx1RkbP7klU3nK4CdmhoWfKHHyhOSTzyQcq7qU4SeMtow88WGTeHibXhftaJXobT53I+GeUuHjtK3LcPgJfsJwluQJySefSTgGP83NT+f8KEnzOdQPUeLkCcknn0k48lTKreMnrxKXO4P6JEqcPCH55DMJR5WXchv5yXfwbTAY8G+v/sUwDMOwCq29/DT2o+jkt1GfJBBqjLLy94iRfEQ+U8Eo4ob5ydOYrygmAVX0R7RltO8kn3wm4Qh+qoCfQAriTzz8JB+RzyQcwU/EnxDxJ9p3kk8+k3AEP7ks8Vt1/Onqv6STyK+fBzy6H3862R0mJT4K6n3+xLWHuye5m6jrNooe/mBUe360qe3rePLbkM9JrY8egv4kXNSthloc1F9+StYkqoCftPGnEJ5W/uXq9K/z61qEEjul+8yhqs6D5og/hS142niHzZqmQUsoxys/pZcIb6qGdtX88Cd+rZ/81IvkN5/PaTUXz10HCcqW8Gly/bUsCH6qO/7kRjRwT3fiT27tV938VFO7SvyJ+FM7MKKbeW1MuJRaKhn8tJD8pIk/GcDo/Lq0JvT5uH8v2jPt7YuPlPv/8vtMglnhVdbXrSdJNsBpfuNPBkxJo+thCCKORuQ72uIj5a63/D6TtjG8ymg0zEQ0pr+4TfxUS7sKP8FPTcf5okrfzay2xLyTZ50AFPzUlfhTYWAp2iHdTTpg+jEkn2mXn7Jl+inpI0x3yJ1EAFtMWgzB8hp/Kmy9oh208fbpR6mvTdky/ZT0EWY6LBK00vJTHe0q/AQ/NZzP018a3UQI+Al+Iv6khJSS3eTt0XfnpTPkYUvZkvyZO0m8ieBTU/GnfEjJMMo7/C5Q2sIT25apT05cM/En+Km3Pqbrw4DgJ/ipT/EnPUCdXx9k40MZfsrGh66W4yd9kGnSb0j8qf7xT9Jo1hwAqQO7T2bjp8gpB6NcEIvxT/BT7/K58xjB+Cf4qU/xJ/37d3FvWoJSmf47qbcu7pwr7r+T+Uk9SXoTjFRv5P27bPOW77+Teuvizrni/rvsJQaq32jX+3fwE66tFoxQHysCbwh+6tL8T5ketun4pOTLZHC5w/jxHBSldJQ/CePHm53/KdNNF7Zv0YDyZOiS8/hxXWwp86428z/BTz32Md2eBon5n+CnFvLTgsw/LsWtUGvjT1XKyeG2yCsz/zgOgHwm4Qh+asn6d/JcBwSPFiP+NDc05aJPBfu2J14PP+EAyGcSjuAn1r9DTcefaN9JPiKfqWAUcUv46ZwH+Yw/ob7Fn2jfST4in0k4RdwyfjrjTcSfiD8h+Ik6QD6TcNRNfvJtAqH4t1f/YhiGYVhV1ur+Ox/yenLEb0HyhOQj8pkKRhE3zE/+xo9T9lR08oTkI/KZhCP4CX5CtGXkCcknn0k4gp/gJ0RbRp6QfPKZhCP4aU5+2k+mp1zf8cJP2WU0Zpten7WMFrGit6fEa1/LhfVb+pz8NuRzMvlsJzOa9VvgpxbxU7C1FGPT4fbyYGPPDz+V9ojw04LyU0tKvPa1hM0Pf0Jw/eSnXiS/+XxOV4LsJqqyfjD81K74k8xSK1uH8BPqOj95rFfEn/qc/MbzWa7X4nP38toGjnFqqWTwU/38VGP8KdwyGg2j5c2C3WG8zpm0ffo7VdP/Em4PQ7XS0zI9NrdimrIl2QCS1c1PDZW4kZ+8tbHwE/zUjvhT+DB0r6FzBEdaePipVn4KO/KWN4M6xj+NguTRlj+I/6VHftrFMn0U0g6XdPt0Q9QiS49MekhuS9x2e+y9oaK3qsQt/OSrjYWf4Kdm8zkeBhT+LoGfEPzknZ/mgaey8Sede8s9BJHfVbdPPk9b4sSZZhx2EuOQtpycpGEP1ED8qf4SJ/4EP/XXx6ShKPgJwU+e+GlOePLIT8kW7cMxaYqDURLVyLbL5iDT5PcZjXgr+anyEmf8E/zUUx/TzTA745+o223ip721wWBt3+v8TzN507jmF/TmJCCU7fzJHpndknYV8fukTfzkr8THrXr/Dn7CtdURhkl7uXn/DsFPXvkpnfxpIl/v32VnA0p75jXRiGFmjLc6mlh6NLIB6mT6j2Rbfgvjx+try9pR4sz/BD/1LZ+Z/4kqBj/1cv7x2X450BYvdkXvZIkz/zjPBflMwhH81GJ+kntyUB/4aUFKHH7iuSCfSTiCn1j/DtGWkSckn3wm4Qh+mmw850HwExUdkSdUCfKZhKPO8tMZb6JmU9ER/EQdIJ9JOOomP2EYhmEYhrXT2stPnpiR+BM/FBB5QpUgn0k46mz8acz4cURbRp6QfPKZhCP4CX5CtGXkCcknn0k4gp/gJ0RbRp6QfEQ+k3CKuMX8lCzhsrHnjZ/SqfWtMyCyclFnKnqFJV77Giw+H37Wb2HNgEbyObMlt9SJst7SaFfZErQ+4azfAj+NG1g/eHkzCD/vbJRdSLiAn+SVLNNFfOGn7lb0aku89jWA/Tz8iZPqJz/1IvmtzGdli32pXbEtV0TqlhYmnPWD4adG4k+xHW4vL21fqZyflNps+QlKze9CRa+6xPX81NLaQvyJ+FPb40/6j8l++YdK3dLS32zmRCH4yTM/Xdlc8RF/UsME0ZbQ+Y1Gw8mvIjl8nO+pmfwt7ZwElgGtllb0qks8MPFTK9tJ+Al+ajk/yY9R/pFSf5O07FeKKeG2RCH4ySs/BVtLvsY/aery5ElOu3Ukfyu+CbdJx0Qf053jVqClvTdU9MpL3Bx/amU7CT/BT4vLT+3uu4OfqNutjT+F/XclEaps/ElxiqnvlDXcDeS+bYJPixt/KlHiFn4i/gQ/8ehVyE8Fo87hJwQ/GecvCLaWVrYOaxr/VOBNFQesnIOBqG2t6FWXOOOf4CdUHT+Zhgq1vu/OmnDGP8FP9fNT2HO3vuMx/jQ2vI2VeV1i+nX8peRO1dDFQB+LQO1qy6oq8XFn3r+Dn3Bt7eAn/atqC4FPvH9H3W5Z/CmZ/6lc8Knk/E+5J3f65TDemByQc73Svjwiba7o1ZU48z/BT6hKftJOlbQAfXcFCWf+J/hpzPzjqCcVnTwh+Yh8JuEIfoKfqOgIfqJKkM8kHMFP8BOiLSNPSD75TMIR/BRtPOdB8BMVHZEnVAnymYSjzvLTGW+iZlPREfxEHSCfSTjqJj9hGIZhGIa109rLT56YkfgTPxQQeUKVIJ9JOOps/GnM+HFEW0aekHzymYQj+Al+QrRl5AnJJ59JOIKf4CdEW0aekHxEPpNwirj1/LS/7m39ltLLbrCQ0YJW9JpLvE0LvLB+S5+T33g+Z5+A8CHYVbYEHa1grN8CPzXET1c2VwY++cmySGUl3hTSahs/1VnibVpg2PzwJ66tn/zUi+S3y8eILM9ltrqlg20OzgB+qpWfDreXlzbWl+rgp5l+gMJPHeCnGkpcz0/N1AriT8SfWuJjglG+9qtbupNwqWZRyeCnGvlpb22wvhNsLdUXfwr/HY2Gkx+jacQ5rvNyDHq6sxrMkIO18QGTr5KjAaoWxZ98lriRn5poSOEn+KkVPkb98dCJH5mWjstyIW8EP83DTzsbg7X9v93wy08D2T1GW9IRK1GDGn+Sul1EY6v3pnLXzGSnQPayk2+a6b2hotdf4hZ+aqAhhZ/gpzb4mC723cFP1O2W8VOCTTXFnywOLw1UzLIlf4mp6+b5aUv8yXuJE3+Cn3j0CvO5IzkPP8FP7eGnw+3lzLsZ5RCqTfyUthaMVO07PzH+CX7qZT53tO/OmnDGP8FP9cef1EBUrfxk7c2J+3yyT4a9NyfTT8SPkPbxU+UlPl6U9+/gJ1xbPfncYXzi/Tv4CX7KBQ9y473TLcNhdkh4skWZ7CP6M/bGjB9vLz9VX+LM/wQ/8ejZ8rhDuc78T/BTG/mJ+cdRzRWdPCH5iHwm4Qh+gp+o6Ah+okqQzyQcwU/wE6ItI09IPvlMwhH8FG0850HwExUdkSdUCfKZhKPO8tMZb6JmU9ER/EQdIJ9JOOomP2EYhmEYhrXT2stPnpiR+BM/FFCcJ1/01nqefPK5loQj3Epz/MT4cQQ/wU/4dfIZfkLwE/yE4Cf4Cb9OPsNPCH6CnxD8BD/h1zHyGX7CrbSVn3Y20hUvlraveOEneV0N73Prl17EY851k/q37JJt/ZY6i6B167fomv6TV4aD1d0T6c/hKyfh54PR4GyQ7hn/me6gHrKAfr0fySefG+Qn1m+Bnxrhp7V9n/GndEnfuJJXVr217vZEt7Jstc678LqO+3SYn+osgtatH2xybINB4pn6yE/dTz753Bg/sX4w/NQAP13ZXFneDDzyk8/aXMwos6ycWS0/9SBG5bZ+sP8i0PNTM7ltc2zDV3bDvOgrP/Ug+eRzY/wkNTMsUg0/1chPcdRzZeuwen5yDBGF/45GUe/L9MMoSLtjJntP9twdJTHa+Ovc+W0nl88ZP2Jyp890ZzV2IseGHa4r/Zmcfrgb6A/sQ/zJaxGY+KmJhtTu2E4S59RLfup88snnpvipdMgbwU9z8NPe2mAafzrcXh5s7DXHTwkkDRRnmO4T+8PUK+tOPpC9ce6c0zPEn6ReHuFt9c5b7gma7BS499/FLjw6R3/iT3UWgZGfGsjuAsc2/iKIYgP95KeuJ598hp9Qn/hJsmBrqVwIqqL4kxJLGMjSuUzHfjStf1XP4LLFvf9OcvxpyKmP/Xf+i2CB4k+R65IjBD3jp24nn3yGnxD85Hn8kys/ZZ3fySLyU+rJB72KP7WBn9o3/ilySye7q8PR2fjP67tD3QtTneWnLieffGb8E+oRPwlmGqzvxC/ieZm/QPf+Xbaya/lJBii186scP1k7j+L7VO5tnv67XHdk0Ht+8lEEi/L+XeqWDkbSS1JBMtpXWHB2MDoYd5qfOpx88pn371C/4k/76z7HjyvjYVJPOe2XG+rjT0nUJjt+/CQ/ukiZ7qMwVjHIDuJOtwxzI76TLcrcIobrZvobh8r48RP9gf3iJw9FsCjzP0lu6WR3NX3JPIwNJNVGevNcrk7C26lbFtWvdzb55DPzP6Ge9t8x/ziqs6J3N0/w6xj5zPzjCH6CnxD8BD/h18ln+AnBT/ATgp/gJ/w6+Qw/IfhpNn4650HwExUdwU/wE/kMP6HO8tMZb6JmU9ER/ATckM/wE+omP2EYhmEYhrXTWt1/50PEn/ihgMgTqgRhTuJPqLPxpzHjxxHOkjwh+fAT/ITgJ/gJ4SzJE5IPP8FPCH6CnxDOkjwh+Qh+gp9oQ9rMT3tr02nvpwvhwU++lVngMll2IL+yTbx5V9kSaBYrSDckC6OoC6XkjjqxnrlwFYSFL3EPK2X1fH2JoirB0q6e+SlcfUW3TnC4Ft7ZIN0z/rMz69+xfgv81AQ/7WwMBht704Xwyi2BBz/N4rGzj/h0fVyDaxG757ZFWzSLZSqHp+vnxtewL7EZndl+P3XyUw3LgNbJT/1Y39RcJZSaj3zxU3Z5u57wE+sHw08N8NPe2mB5M6D/rqH4U25d3ZxvCUb5hmC6RWKb6Ufrkr3TfdSjlDPb74f4U/mH35r5xJ9QZfw0fGU3zOWe8VM/ni/4qV38FGwtle62c+UnuZdIuKuci44+p/vkIiXmffTucDQaRnsEu0NdV5ahbyv3p9wZlpJOrn+s6JxOXiSN94RHZw40I5Eme6Tbi7/Kh6a0mZq/luV+Zoq1zF/i0r+7o6KysN1D3FU5rRujoLAo5Z0revhtmQ8/oUr56SRhoN7wU0+eL/ipdfy0sr624nH8UzYMovem0ibZd9r30bvM2P9lvLJ6bNyOTzu5cn+qty994XpOVy8Ss1roseVkmfru9I1FlnuynKGJa+eyUL6W6X6cK3pFJZ78O1BzXhe+U6pCOp4s6vGUWCkdM2a6mUHJFhh+gp+a56fxF0EUgoKfEPzkN/407b873F6eDoSqkp9MfjG3JTOKeRI8KtznxHyt3AfNsVmyyIGGSwSl+Jwze5EUgfT7GHv99FEqZUCA+SiX+3Gu6BWWuIWrxkUkbTpq1puBn+CnBeSnkJDkQBT8hOAnH+OfkjHjYSyq8vHjrt5UG/Wx7jOeiZ/0x05iLblQUGYQ9Qz3bDinsxfJnNE6nKmgs9+IGYajDM1NcY57L/H6+Ml8M1U9/Ix/gp9q5acvTnZXh6Oz8Z/Xd4e69/IY/4Tgp/nev1vb9xd/kllk+lEd/ZPrcpI61Gz7OPOTemymNycaKyUfUHR1l3OeOHmRzEtyzvikjS3lOqU0PXr6V1QyZzbcz0wVvaISt/Xkluq/U/o34xLTFWXl/NT39+9wbXXz0yTIlL6LFySDyoUFZwejgzHv3yH4qe3zPyWDsYfDZPhzbou8kzLg27iPMz/Zzq8dP57p0lE3uZ3T0Yto5luy9d3lj5Kpwz7bk3aL5czl53+qpMQt0aaZxo9rw072m/HBT8z/BD/VzU9hCCqdyyAMQSVPjTTBQUsLHqsAABZ4SURBVGYCuAPNFuZ/QvBT8/OPd+OHAS7AvaL7LvH2lQXzj/NcNMlPzD+O4Cf4yc15DtTps7056sKIR4O31yt+UsuiRVkNP+EA4Cf4CcFPzJ+JcJbkCcmHn+AnBD9NNp7zIPiJio7IE6oE/AQ/oc7y0xlvomZT0RH8RB2An+An1E1+wjAMwzAMa6e1uv/Oh4g/8UMBkSdUCeJPxJ9QZ+NPY8aPI5wleULy4Sf4CcFP8BPCWZInJB9+gp8Q/AQ/IZwleULyEfwEP9GGtJWfgq2l7MSD0Vp48JMvuaypYtkiL7uS3aSZ4dOwnkzB6jEVrN+yKPIwvSfrtxRVfybv98lP4eorunWCw7XwzgbpnvGfnVn/jvVb4KeG409XNldKLYEHP7n76/zCweqyl+qWdEHe2P1oFstUPFNmKeDcunG51Xylw9UtTfFTDav91MlPfV8/WKl7yBc/ZZe36wk/sX4w/NQsP+2vL21fof+u3tiHRCnTj8qW3NK32n00jYa0JYtC6V+aM88CF8SfZsgTtciIPyEf/DR8ZTfM5Z7xUz+eL/iprfx0ZXNleTPwMf7pJF32O4xt5Jx2LjIyyMVgzPvo3eFoNIz2CHaHuq4sQ99W7k+5M0wKGGX7x4rO6RKKUhOqSXoaEwqP0u8j3V78lSk0lW1psmfWxsrKxFrmL3Hp391RUVnY7iGJ2EV1YxQUFqW8c0UPvzYP4Cfkg59OEgbqDT/15PmCn1rKT8HW0saej/Hj2TCI0flnnb7LPnqXGfu/jFdWj5U6wsIPuT/V28/2vDmds4ierNgwVggo8u7Cq7swVpYzcpmlHf80PbPMHmXHP1VU4sm/AzXndQE0HZ5mQFVipXTMmOlmBiVbYPgJfmqen8ZfBFEICn5C8JN/ftrZKDVyvJifXABBjgckwaPCfU7M18p90BybIwsFNAojKMXnLIansTM/yf6ncB8FUXK76H1YCmDOASjvJW7hqnERSZuOmvVm4Cf4aQH5KSQkORAFPyH4yRM/BVtLK1uHf2+Sn8xjb0z7jGfiJ/2xk+hLLhgThaMcoiNu57TAU86hmMY/aZjG2tlfhBlaH6ZJT2Ez5L3E6+OnWYd+zf7wM/4JfqqVn7442V0djs7Gf17fHerey2P8E4Kf5uOnw+3lkiPHHfrvJBaZflTH36jvpbns48xP6rGZ3pxorJR8QNHVXc55YmIrk6s2vn+XeZHO8P6d2iml79HLNi/qmR1yubCiV1Titp7cUv13Sm7EJaYrysr5qe/v3+Ha6uanSZApfRcvSAaVCwvODkYHY96/Q/DTvPy0tzYoNW2B6/jxZDD2cJgQQm6LvJMy4Nu4jzM/2c6vHT+e6dJRN7md05IT+rHqc83/pMkdw4QorvM/FTZCfkvcEm2aafy4Nuxkvxkf/MT8T/BT3fwUhqDSuQzCEFTy1EgTHMhNkoAqdQvzPyH4qfn5x7vxwwAX4F7RfZd4+8qC+cd5LprkJ+YfR/AT/OTmPHPy50s1s3u36fZ6xU9qWbQoq+EnHAD8BD8h+In5MxHOkjwh+fAT/ITgp8nGcx4EP1HREXlClYCf4CfUWX46403UbCo6gp+oA/AT/IS6yU8YhmEYhmHttFb33/kQ8Sd+KCDyhCpB/In4E+ps/GnM+HGEsyRPSD78BD8h+Al+QjhL8oTkw0/wE4Kf4CeEsyRPSD6Cn+An2pAW81OwtRTNOVh6CWH4yV0uq7Uk27NzT+rXXZGWvcvP8KmuJ1O4Dkxm4ZqiiSgXvsQ9TO/J+i1F1Z/J+33yU7j6im6d4HAtvLNBumf8Z2fWv2P9FvipAX66srkyWNsPP+9sDEquIgw/ufvr/Oq8pmUvJyAT/51QTdwwaI5SPFNmceDcisLxzvZFN8U2a0vkt8RrWO2nTn7q+/rBSh1Gvvgpu7xdT/iJ9YPhp2b4aXkzmHzeXx9s7MFP9cY+JOyRPoZfjkZDY/xJ/ag2GtIWHVvFRKU5ZXK9gmaI+NMMeWLNauJPqDJ+Gr6yG+Zyz/ipH88X/NQyfvrb4fZyFHba2ZgGoqrmJ7lPSLgr2Wkln9N9Jn+77KN3h4I6oj2C3aGuK8vQt5X7U+4MkwJG2f6xonO6hKK0CY0aAMW5p82C5ijp9qSoVUFoSn91Z7bwW+LSv7ujorKw3UMSaYvqxiRn7UUp71zRw2/LavgJVcpPJwkD9YafevJ8wU9t46eoC0+oZOddET9lwyB6byptkn2nfR+9y4z9X8Yrq8dKHVjhh9yf6u1ne96czllET0ZQNEWUrPyU9s3lOgnziBFti3awNDpFfXeWil5RiSf/DtSc12WEDk8zoCqxUjpmzHQzg5ItMPwEPzXPT+MvgigEBT8h+KmW/rskEFUpP5n8Ym5LZszyJHhUuM+J+Vq5D5pjc2ShgEZhBKX4nMXwZM+e2fhJi3zGAQHW6Jezn/Ne4hauGheRtEu2utwM/AQ/LSA/hYQkB6LgJwQ/Vc5PwdZS8tqd/Ll2ftKPz7HtM56Jn/THTvrpci+1ReEoh+iI2zkt8JRzKHGvnYkTreOflGxwYizDeRwbIO8lXh8/mW+mqoef8U/wU6389MXJ7upwdDb+8/ruUPdeHuOfEPxUPv60tzZI408+xo9LLDL9mK3pao+M3KFm28eZn9RjM7050Vgp+YCiq7uc88TEViZXXTgAKTe+PHOU2iml9ug5v/3nig9+S9zWk1uq/07p34xLTFeUlfNT39+/w7XVzU+TIFP6Ll6QDCoXFpwdjA7GvH+H4Kc5xz/tr8exjvUdL/M/JYOxh8NhMjwpu0XeSRnwbdzHmZ9s59eOH89EgdRNbue05IR+rHpBEMQ+/5Mmd8rt4+7j/Ja4Jdo00/hxbdjJfjM++In5n+CnuvkpDEGlcxmEIajkqZEmOMhM93ag2cL8Twh+an7+8W78MMAFuFd03yXevrJg/nGeiyb5ifnHEfwEP7k5z4H7ZNnVXcsxDXXeXq/4SS2LFmU1/IQDgJ/gJwQ/MX8mwlmSJyQffoKfEPw02XjOg+AnKjoiT6gS8BP8hDrLT2e8iZpNRUfwE3UAfoKfUDf5CcMwDMMwrJ3W6v47HyL+xA8FRJ5QJchnEo46G38aM34c0ZaRJySffCbhCH6CnxBtGXlC8slnEo7gJ/gJ0ZaRJyQfkc8knCJuMT8l67eUW/zOiZ+kBTeyy66hjlb02kpcu6hLcxNo9nwBE9ZvaTyfk8lkO5nRrN8CP7WJn9L1g3c2Bmv7XvhJWlDWtD4rRNWpil5jiWvWOhybl5huME8SvusnP/Ui+c3nc/rkdRNVWT8YfmoRPwVbSytbh8nnciGoAn6ClvpW0esscT0/NVbHiD8Rf2qHj+lmI2sDR2mVdCoZ/FRz/Olwe3mQsFSl8afwp2fmUZ482rsjpX8n/Hc0kn+nqlvkn7LRWdN9RrvxN+BZ48GGeko8MPFTQ60o/AQ/tcLHNBaBbSbh8tPPz3P4qf7xT0sb60t++El2gLH/S3xj6kcn/w7SIGy4h7pFfjryR8Wtc0fbjoWq6PWUuDn+1FArCj/BT43nc/Ts9Wr8E/wEPzXDTzJIeeMnqf1MfOdY503l7blxM8mWgazhbiD3fBN8allF91viFn4i/gQ/9fnR6+aPSPiJut1Ofgr777yMf1IbUEdvatqSaxaUx2XyIgbNdEsquucSZ/wT/MSjV4QU3U8445/gp/r5KdhaGqzvTAdC+Xn/LuP+CqMRUidP3JuT3aJuyrzBro9FoJp/C9ZU4uMFev8OfsK11fno9Sv+xPt38FMz8aca5n9KZ+ZIxwibohHDzAhwdUvmfMloYullecaPt6Ci11bizP8EP/HoaR+9TraBzP8EP7WLn1o0/zgzHfSponeyxJl/nOeiBp3+93+RcEQRq/rTn/50/fp1+Al+gp8ACJKPwAgSThHDTwhnSZ6QfARGkHC0oPx0zoPgJ5wlIk+oEmAECUed5acz3kTTibNE8BN1AIwg4aib/IRhGLZwJlpVDMP6YO3lJ0/MSPyJYAMiT6gShGFIOOps/GnM+HGEsyRPSD4YQcIR/AQ/IZwleULy8TEkHMFP8BPCWZInJB+BESScIm47P+1sSIvfJSu6TJfGm5+fpLU1ys+tz1yaC+Qsay7x1qziwvotfU5+G3zMyZV4UpkrJ7ktV076lXAEP/nmp8Pt5cjXxPx0ZXNleTOYfrW0fWV+foqWkE3catkGVF43jVrWamdZe4m3ZhVhc54kZNdPfupF8hv3MY9uXIzpIf4osOLijUdTwFh4sjA6V5HcaTLTTwh+qj3+tLeWhJ32150WFS7gp6qIB3JaFGdZf4nr+amBOkP8ifhTS3xMxBEyTYjPiw5QxoRLcNgFTqRuLyg/BVtLK1uHf1c+zxF/Cn96ZryY7NXSGMNoJP9C1W+RohFpT83k73T/0W78DbjVYLChzhIPTPxUu8OGn+CndvgYNf4Ubln0yIwl8CZjIgEo+Kkz/CS7vsTzKd40drjTThftltSbSqfInyFuoxvovYGfGilxc/yp9gAU/AQ/tcHHyKwUDwy6eOXKRfgJwU8Lx09S+5kb0aKOcYmcp2lL6jtlDXeDZP/pdwSfmnaWtZW4hZ+IP8FPvfMxpkBTGoqCnxD8NF6I8U9qA1roTS1bUm+abYiVQIO4EoNVm+enekqc8U/wEz7GCk+ZweXdSzjjn+CnVvBT1e/fZRzf9MUsqRlN4hPxFqk3R9mS6c3Jfp0ZJaOPRaB6nGXdJT5eiPfv4Cf4qRaMyMJDCk3KV51KOO/fwU+t4CcP8z9NQkGZt5elocDD2EcOM6O+9VvkKEVy1vwImxPGjzftLGsuceZ/gp/wMWN5DqRoxNOEI5j/CcFPnZ5/XA0VETxaeGfZxxJn/nGei/b7GBKO4Cf4CcFPAATJx8eQcEQR95afEM6SPCH53dfT+7f+EurW/adz7Aw/dbx6fHLqoTp5OkPP+OmcB8FPOEtEnrQz+aef/EVWo54iuRcXDwk/wU/wU5v46Yw34U1xlgh+ajU6NY9QVcefpglsjfeDn+CnDvMThmHYwploVWe2f/zH1X//1/81sb/cSbb/563L/3r1xn+WOWHdFt5qeP+X/+O+aZ87H0wS+P6tf/zXIqQIcyvx//1/Kqsh3s9Qsc2JXx75ifAAQqgvfT1OXWXx729NZGr6VbhJ2iveQ/vDXY4fTD+Lj/GdiI+ao3J3IF1F2llzA7rgWpRUa0xB/VK3e3rLvvd3KZfsXsVFZr64tlA0p81lXTar1Zu2HGu52/yp08zLXsF89YIa4p4h5jM4PTjuSY7SEm6SUjXdQ90CPyGEUBvxSUsu6QGGr+PGPfk6vUDGN6mHa/jJdA3DGTJ3aOQne9IVcEh2T52WvI/v/Z0KpqBM8l8X4kLuUM1pbZhaxL8FpZum2tC/XLRHcvWCGlIqQxwIZo4km1JsywP4CSGE6pOGbkx7qJ4yG8ZJT5LdQblE1jWph6veKzt8KR99UM6gJko7/qlgTEsOXjS/+rM34nt/Y8nEX4sz5NJfVGQuuCBdPD6LfNpcTERBFunmDMe6VzAlp4wnz129sIaUyJDiHx5zJFlJo8xbpkoOPyGEUIv4SQcZegAyd4dkScHkmQwdLuNMD6H8raWLMM9LpcaPZw7SdJQZEMHb/q5lV6bIXArFEg3T5K8VFme5W0v9ysKG+eqFNWSW/jtH/J4nyZokufX3wk8IIdQWftJ6gcxG21il3K9pabyTPchSKv5UNT/J540HBH3yiTEh3vc3F44+GjNLkRlwwcy0+lpU1MWqObbwbjU76OmouA/ZCz8ZHp15kqyrsA5EBT8hhFB9UjoZfPCTbdy0Cz9pXaQyorlqfpJvLTpBOp46/aQPi3jZv5ihJju3i59MdaQefqoh/gQ/wU8IoV4HoGZwA4X9dyqUJd7hE5MbcIg/GUbteuOn9N4++ST/iqGakBr2d8PgCvvvdPzk2H/nGub0039XeI35+angl8c8SYafEEJogSJQmjeo5W4kdbi2aWitOjp2bHm53IGf0phMOe9o+MU/aweZZqCS9QX+qvfXBeXyhWIfsZ8cmvP9ShWwFko2dpi9onK/+RHclmNNd1s0ttr96uYa4poh5kpuDKyWSTL8hBBCixWDcp0AYKaXw9XddGENC9rorzBL/50W31xmvpKPU1/msk5TVPn++fvVZEu+v9QYtTO9H2/jJ/1R5pspfiNfffVQe7fFNazg6jMQdkGGOKTPPqmCY5LhJ4QQWrwwlM7VZ781dZ9lJjk0U5oWlWyhIev0T078pJsfwMkBqS/LS3djGdviYX9zJ9NfimFHvXSusNIZG8e2V/9s4bR8MeWPth1bcLc5+k7n93S6+sw1xJQhuQkti4eHlU0y/IQQQr2JXhW244WTaRdcQDMTUbnJAxHqueAnhBBaGH4qetOv6ED3V58QQvATQgh1gp9K41O5tTMQQvATQggtOj+Vx6fM4XMu+4UQgp8QQgghhOAnhBBCCCH4CSGEEEIIfkIIIYQQgp/gJ4QQQgjBT/ATQgghhBD8hBBCCCEEPyGEEEIIwU8IIYQQQvATQgghhBD8BD8hhBBCCH6CnxBCCCGE4CeEEEIIIfgJIYQQQgh+QgghhBCCn+AnhBBCCMFP8BNCCCGEEPyEEEIIIQQ/IYQQQgjBTwghhBBC8BNCCCGEEPwEPyGEEEIIfoKfEEIIIYQc+Ontt9++fPky/IQQQggh5MRPf/3rXyN+unnz5meffTYDP52ensJPCCGEEOqbtra2Xn/99YsXL169evXWrVuCnwQUFfPTP//5T/gJIYQQQv3Uyy+//MYbbxwcHARBcHR0dO/evYifBCAV8NOTJ08ePnwIPyGEEEKob3r11VffeuutS5cuffjhhx9//PHnn38uoEigUTE/PX369NGjRw8ePLhz5861a9fef//9d95558033xRn/M1vfrO1tfXrX/96c6JfIoQQQggtrCKeEWAj8EZAjkAdATwCewT8CAQSICRwSECRQCMjPwlF/PTs2bPHjx9//fXXd+/evXnz5gcffPDuu++Kc/3+979/4403Xn/99ddee+13v/vdbxFCCCGEFlwCaQTYCLwRkCNQRwCPwB4BPwKBBAgJHBJQJNAo4icBSxp+ElT14sWL58+f//jjj6enp/fv3799+/ZHH30kzvLee+9dunTp4ODg4sWLb0/0B4QQQgihBVdENQJvBOQI1BHAI7BHwI9AIAFCAocEFAk0EoAkMCnPT2oX3vfff//NN9/cu3fvzp07AsGuX7/+5z//OQiCq1evXo71R4QQQgihhVWCNAJvBOQI1BHAI7BHwI9AIAFCAofkzjs9P8khqJ9++um7774TRwr4unv3rqCwjz/++Ojo6OZENxBCCCGEOqGIbQTkCNQRwCOwR8CPQCABQgKH5OCThp9yIagIoQR2nZ6efvXVVw8ePPj8888Fi3322WcnCCGEEEIdksAbATkCdQTwCOwR8CMQKIInOfgkYGmgfW0vh1BPnz4VBz9+/PjRo0cPHz48jfUtQgghhFAnlOCNQB0BPAJ7BPwIBFLhycZPCUK9ePEioqhnz56Jszx58uQnhBBCCKGOSqCOAB6BPRE5CRBK4KmAn3IIlVBUpJ8RQgghhDqqBHgiclLhycZPOYpKQAohhBBCqA+K+CdHTk78JFNUTv+DEEIIIdQhaYFHi0b/H8j+UMGGb5jEAAAAAElFTkSuQmCC)
Conclusion:-
So in this way you can get tables and columns with increment value from sql.
Download Source Codes