<div id="readability-page-1" class="page"><section id="container">

<ins data-ad-client="ca-pub-9527582522912841" data-ad-slot="8674651030" data-ad-format="auto" data-full-width-responsive="true" data-ad-type="inventory" data-ad-adfit-unit="DAN-we6apVVPwuoDAazb"></ins>



            



            <div>

<p data-ke-size="size16">도구 &gt; 옵션 메뉴에서 '환경'- &gt; '키보드' -&gt; '쿼리 바로가기' 부분에서 보시면 됩니다.</p>
<figure data-ke-mobilestyle="widthOrigin" data-origin-width="740" data-origin-height="430"><span data-url="https://blog.kakaocdn.net/dn/dPOkFz/btrRfNOWRiJ/GLEkmNhXBRKfTbwhsitaf1/img.png" data-lightbox="lightbox"><img src="https://blog.kakaocdn.net/dn/dPOkFz/btrRfNOWRiJ/GLEkmNhXBRKfTbwhsitaf1/img.png" onerror="this.onerror=null; this.src='//t1.daumcdn.net/tistory_admin/static/images/no-image-v1.png'; this.srcset='//t1.daumcdn.net/tistory_admin/static/images/no-image-v1.png';" data-origin-width="740" data-origin-height="430"></span></figure>



<pre id="code_1636949900701" data-ke-language="sql" data-ke-type="codeblock"><code>Alt+F1  sp_help
Ctrl+F1 sp_helpindex
Ctrl+1 	sp_who
Ctrl+2 	sp_lock

Ctrl+3 	sp_helptext 

Ctrl+4 	sp_helpstatus 

Ctrl+5 	select top 1000 * from

Ctrl+6 	sp_spaceUsed 
Ctrl+8 	set statistics profile on;set statistics io on;set statistics time on;
Ctrl+9 	set statistics profile off;set statistics io off;set statistics time off;</code></pre>



<figure data-ke-mobilestyle="widthOrigin" data-origin-width="761" data-origin-height="528"><span data-url="https://t1.daumcdn.net/cfile/tistory/237B993457030A1937?original" data-lightbox="lightbox"><img src="https://t1.daumcdn.net/cfile/tistory/237B993457030A1937" onerror="this.onerror=null; this.src='//t1.daumcdn.net/tistory_admin/static/images/no-image-v1.png'; this.srcset='//t1.daumcdn.net/tistory_admin/static/images/no-image-v1.png';" width="761" height="528" data-origin-width="761" data-origin-height="528"></span></figure>


<hr contenteditable="false" data-ke-type="horizontalRule" data-ke-style="style3">

<p data-ke-size="size16">이걸 단축키 지정해서 별도로 사용해도 좋을 내용입니다.</p>
<p data-ke-size="size16">sp_help 에 안보이는 '설명' 내용을 볼 수 있도록 확장된 버전으로 보시면 되겠습니다.</p>
<pre id="code_1668474749866" data-ke-language="sql" data-ke-type="codeblock"><code>ALTER   PROC [dbo].[sp_HelpTable]  

( @P_TABNAME NVARCHAR(100))  

AS  

SELECT TB.NAME,     
       CAST(q.[VALUE] AS NVARCHAR(1000)) AS TAB_CMT    
FROM SYS.OBJECTS TB   
	LEFT OUTER JOIN SYS.EXTENDED_PROPERTIES q  ON (q.MAJOR_ID = tb.OBJECT_ID   
                                               AND q.MINOR_ID = 0  
                                               AND q.CLASS = 1   
                                               AND q.NAME = 'MS_Description')  
WHERE TB.NAME = LTRIM(RTRIM(@P_TABNAME))  


SELECT clmns.name as [Column Name],
       ISNULL(CAST(ep.value AS nvarchar(4000)), '') as [Description],
       clmns.column_id as [ColumnID],
 	   CASE WHEN usrt.system_type_id IS NULL THEN 'Null'
		    WHEN (usrt.system_type_id &lt;&gt; usrt.user_type_id) AND (usrt.name = 'sysname') THEN 'sysname'
		    ELSE ISNULL(baset.name, '') END as [Type],
 	   CAST(CASE WHEN (baset.name in ('nchar', 'nvarchar')) AND (clmns.max_length &lt;&gt; -1) THEN clmns.max_length / 2
                 ELSE clmns.max_length END AS int) as [Length],
       CAST(clmns.precision AS int) as [NumericPrecision],
       CAST(clmns.scale AS int) as [NumericScale],
       CAST(ISNULL(cik.index_column_id, 0) AS bit) as [PrimaryKey],
       CAST(ISNULL(cik.key_ordinal, 0) AS int) as [PosInPKey],
       CASE WHEN cik.key_ordinal IS NULL THEN ''
	        WHEN cik.is_descending_key = 0 THEN 'A'
			ELSE 'D' END as [OrderInPKey],
       CASE WHEN clmns.is_nullable = 0 THEN 'NOTNULL' ELSE 'NULL' END as [Not Null],
	   ISNULL(clmns.collation_name, '') as [Collation] 
FROM
  sys.all_objects o INNER JOIN sys.schemas sc ON (sc.schema_id = o.schema_id)
                    INNER JOIN sys.all_columns clmns ON (clmns.object_id = o.object_id)
                    LEFT OUTER JOIN sys.identity_columns ic ON ((ic.object_id = o.object_id) AND
                                                               (ic.column_id = clmns.column_id))
                    LEFT OUTER JOIN sys.computed_columns cc ON ((cc.object_id = o.object_id) AND
                                                               (cc.column_id = clmns.column_id))
                    LEFT OUTER JOIN sys.all_objects o1 ON (o1.object_id = clmns.default_object_id)
                    LEFT OUTER JOIN sys.all_objects o2 ON (o2.object_id = clmns.rule_object_id)
                    LEFT OUTER JOIN sys.check_constraints ch ON ((ch.parent_object_id = clmns.object_id) AND
                                                                (ch.parent_column_id = clmns.column_id))
                    LEFT OUTER JOIN sys.indexes ik ON ((ik.object_id = clmns.object_id) AND
                                                      (ik.is_primary_key = 1))
                    LEFT OUTER JOIN sys.index_columns cik ON ((cik.index_id = ik.index_id) AND
                                                             (cik.column_id = clmns.column_id) AND
                                                             (cik.object_id = clmns.object_id) AND
                                                             (cik.is_included_column = 0))
                    LEFT OUTER JOIN sys.types usrt ON (usrt.user_type_id = clmns.user_type_id)
                    LEFT OUTER JOIN sys.schemas scparam ON (scparam.schema_id = usrt.schema_id)
                    LEFT OUTER JOIN sys.types baset ON ((baset.user_type_id = clmns.system_type_id) AND
                                                       (baset.user_type_id = baset.system_type_id))
                    LEFT OUTER JOIN sys.extended_properties ep ON ((ep.major_id = o.object_id) AND
                                                                  (ep.minor_id = clmns.column_id) AND
                                                                  (ep.class = 1) AND
                                                                  (ep.name = 'MS_Description'))
                    LEFT OUTER JOIN sys.xml_schema_collections xscclmns ON (xscclmns.xml_collection_id = clmns.xml_collection_id)
                    LEFT OUTER JOIN sys.schemas s2clmns ON (s2clmns.schema_id = xscclmns.schema_id)
WHERE o.name = LTRIM(RTRIM(@P_TABNAME))  
ORDER BY clmns.column_id ASC;</code></pre>


<figure data-ke-mobilestyle="widthOrigin" data-origin-width="1278" data-origin-height="412"><span data-url="https://blog.kakaocdn.net/dn/ddvrL3/btskuQjMejR/bR8koPLWEfnxKPypWHK07k/img.png" data-lightbox="lightbox"><img src="https://blog.kakaocdn.net/dn/ddvrL3/btskuQjMejR/bR8koPLWEfnxKPypWHK07k/img.png" onerror="this.onerror=null; this.src='//t1.daumcdn.net/tistory_admin/static/images/no-image-v1.png'; this.srcset='//t1.daumcdn.net/tistory_admin/static/images/no-image-v1.png';" data-origin-width="1278" data-origin-height="412"></span></figure>





<p data-ke-size="size16">해당 출처 : <a href="https://skystep.tistory.com/83" target="_blank" rel="noopener">https://skystep.tistory.com/83</a></p>
<figure id="og_1668476136861" contenteditable="false" data-ke-type="opengraph" data-ke-align="alignCenter" data-og-type="article" data-og-title="[MSSQL] TABLE 정보 쉽게 확인하기" data-og-description="[특정 테이블 정보 쉽게 확인 Query] set ANSI_NULLS ONset QUOTED_IDENTIFIER ON create PROC [dbo].[SP_HELPTABLE] ( @P_TABNAME VARCHAR(100)) AS SELECT TB.NAME, CAST(q.[VALUE] AS VARCHAR(1000)) AS TAB_CMT FROM SYS.OBJECTS TB LEFT OUTER JOIN SYS.EXTEN" data-og-host="skystep.tistory.com" data-og-source-url="https://skystep.tistory.com/83" data-og-url="https://skystep.tistory.com/83" data-og-image="https://scrap.kakaocdn.net/dn/R5Jce/hyQzbKd05O/Lg7col7dHOmsSIjcmaJzH0/img.png?width=800&amp;height=800&amp;face=0_0_800_800,https://scrap.kakaocdn.net/dn/ciflgT/hyQzq1ILfX/QctFRwl9X5iSH2Ew872lnK/img.png?width=800&amp;height=800&amp;face=0_0_800_800"><a href="https://skystep.tistory.com/83" target="_blank" rel="noopener" data-source-url="https://skystep.tistory.com/83">

<div>
<p data-ke-size="size16">[MSSQL] TABLE 정보 쉽게 확인하기</p>
<p data-ke-size="size16">[특정 테이블 정보 쉽게 확인 Query] set ANSI_NULLS ONset QUOTED_IDENTIFIER ON create PROC [dbo].[SP_HELPTABLE] ( @P_TABNAME VARCHAR(100)) AS SELECT TB.NAME, CAST(q.[VALUE] AS VARCHAR(1000)) AS TAB_CMT FROM SYS.OBJECTS TB LEFT OUTER JOIN SYS.EXTEN</p>
<p data-ke-size="size16">skystep.tistory.com</p>
</div>
</a><img src="https://scrap.kakaocdn.net/dn/R5Jce/hyQzbKd05O/Lg7col7dHOmsSIjcmaJzH0/img.png?width=800&amp;height=800&amp;face=0_0_800_800,https://scrap.kakaocdn.net/dn/ciflgT/hyQzq1ILfX/QctFRwl9X5iSH2Ew872lnK/img.png?width=800&amp;height=800&amp;face=0_0_800_800"></figure>

</div>
            




                    

                    



</section></div>

심재운 블로그

도구 > 옵션 메뉴에서 '환경'- > '키보드' -> '쿼리 바로가기' 부분에서 보시면 됩니다.
 
 
Alt+F1  sp_help
Ctrl+F1 sp_helpindex
Ctrl+1 	sp_who
Ctrl+2 	sp_lock
Ctrl+3 	sp_helptext 
Ctrl+4 	sp_helpstatus 
Ctrl+5 	select top 1000 * from
Ctrl+6 	sp_spaceUsed 
Ctrl+8 	set statistics profile on;set statistics io on;set statistics time on;
Ctrl+9 	set statistics profile off;set statistics io off;set statistics time off;
 
 
 
 
 
이걸 단축키 지정해서 별도로 사용해도 좋을 내용입니다.
sp_help 에 안보이는 '설명' 내용을 볼 수 있도록 확장된 버전으로 보시면 되겠습니다.
ALTER   PROC [dbo].[sp_HelpTable]  
( @P_TABNAME NVARCHAR(100))  
AS  
SELECT TB.NAME,     
       CAST(q.[VALUE] AS NVARCHAR(1000)) AS TAB_CMT    
FROM SYS.OBJECTS TB   
	LEFT OUTER JOIN SYS.EXTENDED_PROPERTIES q  ON (q.MAJOR_ID = tb.OBJECT_ID   
                                               AND q.MINOR_ID = 0  
                                               AND q.CLASS = 1   
                                               AND q.NAME = 'MS_Description')  
WHERE TB.NAME = LTRIM(RTRIM(@P_TABNAME))  
SELECT clmns.name as [Column Name],
       ISNULL(CAST(ep.value AS nvarchar(4000)), '') as [Description],
       clmns.column_id as [ColumnID],
 	   CASE WHEN usrt.system_type_id IS NULL THEN 'Null'
		    WHEN (usrt.system_type_id <> usrt.user_type_id) AND (usrt.name = 'sysname') THEN 'sysname'
		    ELSE ISNULL(baset.name, '') END as [Type],
 	   CAST(CASE WHEN (baset.name in ('nchar', 'nvarchar')) AND (clmns.max_length <> -1) THEN clmns.max_length / 2
                 ELSE clmns.max_length END AS int) as [Length],
       CAST(clmns.precision AS int) as [NumericPrecision],
       CAST(clmns.scale AS int) as [NumericScale],
       CAST(ISNULL(cik.index_column_id, 0) AS bit) as [PrimaryKey],
       CAST(ISNULL(cik.key_ordinal, 0) AS int) as [PosInPKey],
       CASE WHEN cik.key_ordinal IS NULL THEN ''
	        WHEN cik.is_descending_key = 0 THEN 'A'
			ELSE 'D' END as [OrderInPKey],
       CASE WHEN clmns.is_nullable = 0 THEN 'NOTNULL' ELSE 'NULL' END as [Not Null],
	   ISNULL(clmns.collation_name, '') as [Collation] 
FROM
  sys.all_objects o INNER JOIN sys.schemas sc ON (sc.schema_id = o.schema_id)
                    INNER JOIN sys.all_columns clmns ON (clmns.object_id = o.object_id)
                    LEFT OUTER JOIN sys.identity_columns ic ON ((ic.object_id = o.object_id) AND
                                                               (ic.column_id = clmns.column_id))
                    LEFT OUTER JOIN sys.computed_columns cc ON ((cc.object_id = o.object_id) AND
                                                               (cc.column_id = clmns.column_id))
                    LEFT OUTER JOIN sys.all_objects o1 ON (o1.object_id = clmns.default_object_id)
                    LEFT OUTER JOIN sys.all_objects o2 ON (o2.object_id = clmns.rule_object_id)
                    LEFT OUTER JOIN sys.check_constraints ch ON ((ch.parent_object_id = clmns.object_id) AND
                                                                (ch.parent_column_id = clmns.column_id))
                    LEFT OUTER JOIN sys.indexes ik ON ((ik.object_id = clmns.object_id) AND
                                                      (ik.is_primary_key = 1))
                    LEFT OUTER JOIN sys.index_columns cik ON ((cik.index_id = ik.index_id) AND
                                                             (cik.column_id = clmns.column_id) AND
                                                             (cik.object_id = clmns.object_id) AND
                                                             (cik.is_included_column = 0))
                    LEFT OUTER JOIN sys.types usrt ON (usrt.user_type_id = clmns.user_type_id)
                    LEFT OUTER JOIN sys.schemas scparam ON (scparam.schema_id = usrt.schema_id)
                    LEFT OUTER JOIN sys.types baset ON ((baset.user_type_id = clmns.system_type_id) AND
                                                       (baset.user_type_id = baset.system_type_id))
                    LEFT OUTER JOIN sys.extended_properties ep ON ((ep.major_id = o.object_id) AND
                                                                  (ep.minor_id = clmns.column_id) AND
                                                                  (ep.class = 1) AND
                                                                  (ep.name = 'MS_Description'))
                    LEFT OUTER JOIN sys.xml_schema_collections xscclmns ON (xscclmns.xml_collection_id = clmns.xml_collection_id)
                    LEFT OUTER JOIN sys.schemas s2clmns ON (s2clmns.schema_id = xscclmns.schema_id)
WHERE o.name = LTRIM(RTRIM(@P_TABNAME))  
ORDER BY clmns.column_id ASC;
 
 
 
 
 
 
해당 출처 : https://skystep.tistory.com/83

mssql 키보드 쿼리 바로가기 단축키 괜찮은 것

댓글