{"id":2221,"date":"2012-07-05T14:16:19","date_gmt":"2012-07-05T06:16:19","guid":{"rendered":"http:\/\/jason695.why3s.tw\/wordpress\/?p=2221"},"modified":"2012-07-05T14:20:34","modified_gmt":"2012-07-05T06:20:34","slug":"%e8%ae%80%e5%8f%96sql%e7%9a%84schema","status":"publish","type":"post","link":"https:\/\/jason695.why3s.tw\/wordpress\/2012\/07\/05\/%e8%ae%80%e5%8f%96sql%e7%9a%84schema\/","title":{"rendered":"\u8b80\u53d6SQL\u7684SCHEMA"},"content":{"rendered":"<pre class=\"lang:pgsql decode:true crayon-selected\">EXEC sp_tables\r\n\r\n\/*\u8cc7\u6599\u8868*\/\r\nSelect * From SysObjects Where xType='U' Order By Name\r\n\r\n\/*\u6b04\u4f4d*\/\r\nSelect * From SysObjects A Inner Join SysColumns B On A.ID=B.ID Where A.xType='U' Order By A.Name,ColID\r\n\r\n\/*\u8b80\u53d6SQL \u8cc7\u6599\u8868\u6b04\u4f4d\u7d50\u69cb\u7684SQL \u8a9e\u6cd5*\/\r\nSelect A.Name As TableName,B.ColOrder As ColOrder,B.Name As ColName,C.Name As ColType,B.Length As ColLen,B.XPrec As ColPrecision,B.XScale As ColScale\r\nFrom (SysObjects A Inner Join SysColumns B On A.ID=B.ID) Inner Join SysTypes C On B.XType=C.XType\r\nWhere A.XType='u'\r\nOrder By A.Name,B.ColOrder<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>EXEC sp_tables \/*\u8cc7\u6599\u8868*\/ Select * From SysObjects Where x &hellip; <a href=\"https:\/\/jason695.why3s.tw\/wordpress\/2012\/07\/05\/%e8%ae%80%e5%8f%96sql%e7%9a%84schema\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587 <span class=\"screen-reader-text\">\u8b80\u53d6SQL\u7684SCHEMA<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[47],"tags":[],"class_list":["post-2221","post","type-post","status-publish","format-standard","hentry","category-sql-server","no-featured-image"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/2221","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/comments?post=2221"}],"version-history":[{"count":0,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/2221\/revisions"}],"wp:attachment":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=2221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=2221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=2221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}