sp_help(Transact-SQL)sp_help (Transact-SQL)

적용 대상: 예SQL Server 예Azure SQL Database 아니요Azure SQL Data Warehouse 아니요병렬 데이터 웨어하우스 APPLIES TO: yesSQL Server yesAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

데이터베이스 개체에 대 한 정보를 보고 (나열 된 모든 개체를 sys.sysobjects 호환성 뷰), 사용자 정의 데이터 형식 또는 데이터 형식입니다.Reports information about a database object (any object listed in the sys.sysobjects compatibility view), a user-defined data type, or a data type.

항목 링크 아이콘 Transact-SQL 구문 규칙Topic link icon Transact-SQL Syntax Conventions

구문Syntax

  
sp_help [ [ @objname = ] 'name' ]  

인수Arguments

[ @objname = ] 'name' 모든 개체의 이름인 sysobjects 에서 모든 사용자 정의 데이터 형식 또는 systypes 테이블입니다.[ @objname = ] 'name' Is the name of any object, in sysobjects or any user-defined data type in the systypes table. 이름 됩니다 nvarchar ( 776 ) , 기본값은 NULL입니다.name is nvarchar( 776 ), with a default of NULL. 데이터베이스 이름은 허용되지 않습니다.Database names are not acceptable. 'Person.AddressType' 또는 [Person.AddressType]과 같이 둘 또는 세 부분으로 된 이름을 구분해야 합니다.Two or three part names must be delimited, such as 'Person.AddressType' or [Person.AddressType].

반환 코드 값Return Code Values

0(성공) 또는 1(실패)0 (success) or 1 (failure)

결과 집합Result Sets

반환 되는 결과 집합 인지 여부에 따라 달라 집니다 이름을 는 지정 된 경우, 및는 데이터베이스 개체를 지정 합니다.The result sets that are returned depend on whether name is specified, when it is specified, and which database object it is.

  1. 하는 경우 sp_help 실행은 인수 없이 현재 데이터베이스에 존재 하는 모든 유형의 개체의 요약 정보가 반환 됩니다.If sp_help is executed with no arguments, summary information of objects of all types that exist in the current database is returned.

    열 이름Column name 데이터 형식Data type 설명Description
    이름Name nvarchar( 128 )nvarchar( 128 ) 개체 이름Object name
    소유자Owner nvarchar( 128 )nvarchar( 128 ) 개체 소유자. 개체를 소유한 데이터베이스 보안 주체로,Object owner (This is the database principal that owns object. 기본적으로 개체가 포함된 스키마의 소유자로 설정됩니다.Defaults to the owner of the schema that contains the object.)
    Object_typeObject_type nvarchar( 31 )nvarchar( 31 ) 개체 유형Object type
  2. 경우 이름을 되는 SQL ServerSQL Server 데이터 형식 또는 사용자 정의 데이터 형식으로 sp_help 결과 집합을 반환 합니다.If name is a SQL ServerSQL Server data type or user-defined data type, sp_help returns this result set.

    열 이름Column name 데이터 형식Data type 설명Description
    Type_nameType_name nvarchar( 128 )nvarchar( 128 ) 데이터 형식의 이름입니다.Data type name.
    Storage_typeStorage_type nvarchar( 128 )nvarchar( 128 ) SQL ServerSQL Server 형식의 이름입니다.type name.
    길이Length smallintsmallint 데이터 형식의 물리적 길이(바이트)입니다.Physical length of the data type (in bytes).
    precPrec intint 전체 자릿수(총 자릿수)입니다.Precision (total number of digits).
    소수 자릿수Scale intint 소수점 이하 자릿수입니다.Number of digits to the right of the decimal.
    Null 허용Nullable varchar( 35 )varchar( 35 ) NULL 값 허용 되는지 여부를 나타냅니다. 예 또는 아니요.Indicates whether NULL values are allowed: Yes or No.
    Default_nameDefault_name nvarchar( 128 )nvarchar( 128 ) 해당 형식에 바인딩된 기본값의 이름입니다.Name of a default bound to this type.

    NULL = 기본값이 바인딩되지 않습니다.NULL = No default is bound.
    Rule_nameRule_name nvarchar( 128 )nvarchar( 128 ) 해당 형식에 바인딩된 규칙의 이름입니다.Name of a rule bound to this type.

    NULL = 기본값이 바인딩되지 않습니다.NULL = No default is bound.
    데이터 정렬Collation sysnamesysname 데이터 형식의 데이터 정렬입니다.Collation of the data type. 문자가 아닌 데이터 형식의 경우 NULL입니다.NULL for non-character data types.
  3. 하는 경우 이름을 되는 데이터 형식이 아닌 임의의 데이터베이스 개체인 sp_help 집합과 함께 추가 결과 집합을 지정 된 개체의 유형에 따라이 결과 반환 합니다.If name is any database object other than a data type, sp_help returns this result set and also additional result sets, based on the type of object specified.

여러분의 의견을 환영합니다. 이 문서에서 단계, 코드 예제 등에 오래되거나 잘못된 부분이 있으면 알려주세요.We are listening: If you find something outdated or incorrect in this article, such as a step or a code example, please tell us. 이 페이지 아래쪽의 피드백 섹션에서 이 페이지 단추를 클릭할 수 있습니다.You can click the This page button in the Feedback section at the bottom of this page. 일반적으로 다음날 SQL에 대한 모든 피드백 항목을 읽습니다.We read every item of feedback about SQL, typically the next day. 감사합니다.Thanks.

|<span data-ttu-id="870bb-164">열 이름</span><span class="sxs-lookup"><span data-stu-id="870bb-164">Column name</span></span>|<span data-ttu-id="870bb-165">데이터 형식</span><span class="sxs-lookup"><span data-stu-id="870bb-165">Data type</span></span>|<span data-ttu-id="870bb-166">설명</span><span class="sxs-lookup"><span data-stu-id="870bb-166">Description</span></span>|  
|-----------------|---------------|-----------------|  
|<span data-ttu-id="870bb-167">**이름**</span><span class="sxs-lookup"><span data-stu-id="870bb-167">**Name**</span></span>|<span data-ttu-id="870bb-168">**nvarchar(** 128 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-168">**nvarchar(** 128 **)**</span></span>|<span data-ttu-id="870bb-169">테이블 이름</span><span class="sxs-lookup"><span data-stu-id="870bb-169">Table name</span></span>|  
|<span data-ttu-id="870bb-170">**소유자**</span><span class="sxs-lookup"><span data-stu-id="870bb-170">**Owner**</span></span>|<span data-ttu-id="870bb-171">**nvarchar(** 128 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-171">**nvarchar(** 128 **)**</span></span>|<span data-ttu-id="870bb-172">테이블 소유자입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-172">Table owner</span></span>|  
|<span data-ttu-id="870bb-173">**형식**</span><span class="sxs-lookup"><span data-stu-id="870bb-173">**Type**</span></span>|<span data-ttu-id="870bb-174">**nvarchar(** 31 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-174">**nvarchar(** 31 **)**</span></span>|<span data-ttu-id="870bb-175">테이블 유형입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-175">Table type</span></span>|  
|<span data-ttu-id="870bb-176">**Created_datetime**</span><span class="sxs-lookup"><span data-stu-id="870bb-176">**Created_datetime**</span></span>|<span data-ttu-id="870bb-177">**datetime**</span><span class="sxs-lookup"><span data-stu-id="870bb-177">**datetime**</span></span>|<span data-ttu-id="870bb-178">테이블을 만든 날짜입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-178">Date table created</span></span>|  

 Depending on the database object specified, **sp_help** returns additional result sets.  

 If *name* is a system table, user table, or view, **sp_help** returns the following result sets. However, the result set that describes where the data file is located on a file group is not returned for a view.  

-   <span data-ttu-id="870bb-179">열 개체에 대해 반환되는 추가 결과 집합입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-179">Additional result set returned on column objects:</span></span>  

    |<span data-ttu-id="870bb-180">열 이름</span><span class="sxs-lookup"><span data-stu-id="870bb-180">Column name</span></span>|<span data-ttu-id="870bb-181">데이터 형식</span><span class="sxs-lookup"><span data-stu-id="870bb-181">Data type</span></span>|<span data-ttu-id="870bb-182">설명</span><span class="sxs-lookup"><span data-stu-id="870bb-182">Description</span></span>|  
    |-----------------|---------------|-----------------|  
    |<span data-ttu-id="870bb-183">**Column_name**</span><span class="sxs-lookup"><span data-stu-id="870bb-183">**Column_name**</span></span>|<span data-ttu-id="870bb-184">**nvarchar(** 128 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-184">**nvarchar(** 128 **)**</span></span>|<span data-ttu-id="870bb-185">열 이름입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-185">Column name.</span></span>|  
    |<span data-ttu-id="870bb-186">**형식**</span><span class="sxs-lookup"><span data-stu-id="870bb-186">**Type**</span></span>|<span data-ttu-id="870bb-187">**nvarchar(** 128 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-187">**nvarchar(** 128 **)**</span></span>|<span data-ttu-id="870bb-188">열의 데이터 형식입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-188">Column data type.</span></span>|  
    |<span data-ttu-id="870bb-189">**계산**</span><span class="sxs-lookup"><span data-stu-id="870bb-189">**Computed**</span></span>|<span data-ttu-id="870bb-190">**varchar(** 35 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-190">**varchar(** 35 **)**</span></span>|<span data-ttu-id="870bb-191">열에 값을 계산 하는지 여부를 나타냅니다. 예 또는 아니요.</span><span class="sxs-lookup"><span data-stu-id="870bb-191">Indicates whether the values in the column are computed: Yes or No.</span></span>|  
    |<span data-ttu-id="870bb-192">**길이**</span><span class="sxs-lookup"><span data-stu-id="870bb-192">**Length**</span></span>|<span data-ttu-id="870bb-193">**int**</span><span class="sxs-lookup"><span data-stu-id="870bb-193">**int**</span></span>|<span data-ttu-id="870bb-194">열 길이(바이트)입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-194">Column length in bytes.</span></span><br /><br /> <span data-ttu-id="870bb-195">참고: 열 데이터 형식을 큰 값 형식인 경우 (**varchar (max)** 를 **nvarchar (max)** 합니다 **varbinary (max)** , 또는 **xml**), 값이 -1로 표시 합니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-195">Note: If the column data type is a large value type (**varchar(max)**, **nvarchar(max)**, **varbinary(max)**, or **xml**), the value will display as -1.</span></span>|  
    |<span data-ttu-id="870bb-196">**prec**</span><span class="sxs-lookup"><span data-stu-id="870bb-196">**Prec**</span></span>|<span data-ttu-id="870bb-197">**char(** 5 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-197">**char(** 5 **)**</span></span>|<span data-ttu-id="870bb-198">열의 전체 자릿수입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-198">Column precision.</span></span>|  
    |<span data-ttu-id="870bb-199">**소수 자릿수**</span><span class="sxs-lookup"><span data-stu-id="870bb-199">**Scale**</span></span>|<span data-ttu-id="870bb-200">**char(** 5 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-200">**char(** 5 **)**</span></span>|<span data-ttu-id="870bb-201">열의 소수 자릿수입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-201">Column scale.</span></span>|  
    |<span data-ttu-id="870bb-202">**Null 허용**</span><span class="sxs-lookup"><span data-stu-id="870bb-202">**Nullable**</span></span>|<span data-ttu-id="870bb-203">**varchar(** 35 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-203">**varchar(** 35 **)**</span></span>|<span data-ttu-id="870bb-204">열에 NULL 값 허용 되는지 여부를 나타냅니다. 예 또는 아니요.</span><span class="sxs-lookup"><span data-stu-id="870bb-204">Indicates whether NULL values are allowed in the column: Yes or No.</span></span>|  
    |<span data-ttu-id="870bb-205">**TrimTrailingBlanks**</span><span class="sxs-lookup"><span data-stu-id="870bb-205">**TrimTrailingBlanks**</span></span>|<span data-ttu-id="870bb-206">**varchar(** 35 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-206">**varchar(** 35 **)**</span></span>|<span data-ttu-id="870bb-207">후행 공백을 자를지 여부를</span><span class="sxs-lookup"><span data-stu-id="870bb-207">Trim the trailing blanks.</span></span> <span data-ttu-id="870bb-208">Yes 또는 No로 표시합니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-208">Returns Yes or No.</span></span>|  
    |<span data-ttu-id="870bb-209">**FixedLenNullInSource**</span><span class="sxs-lookup"><span data-stu-id="870bb-209">**FixedLenNullInSource**</span></span>|<span data-ttu-id="870bb-210">**varchar(** 35 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-210">**varchar(** 35 **)**</span></span>|<span data-ttu-id="870bb-211">이전 버전과의 호환성을 위해서만 지원됩니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-211">For backward compatibility only.</span></span>|  
    |<span data-ttu-id="870bb-212">**데이터 정렬**</span><span class="sxs-lookup"><span data-stu-id="870bb-212">**Collation**</span></span>|<span data-ttu-id="870bb-213">**sysname**</span><span class="sxs-lookup"><span data-stu-id="870bb-213">**sysname**</span></span>|<span data-ttu-id="870bb-214">열의 데이터 정렬입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-214">Collation of the column.</span></span> <span data-ttu-id="870bb-215">문자가 아닌 데이터 형식의 경우 NULL을 반환합니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-215">NULL for noncharacter data types.</span></span>|  

-   <span data-ttu-id="870bb-216">ID 열에 대해 반환되는 추가 결과 집합입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-216">Additional result set returned on identity columns:</span></span>  

    |<span data-ttu-id="870bb-217">열 이름</span><span class="sxs-lookup"><span data-stu-id="870bb-217">Column name</span></span>|<span data-ttu-id="870bb-218">데이터 형식</span><span class="sxs-lookup"><span data-stu-id="870bb-218">Data type</span></span>|<span data-ttu-id="870bb-219">설명</span><span class="sxs-lookup"><span data-stu-id="870bb-219">Description</span></span>|  
    |-----------------|---------------|-----------------|  
    |<span data-ttu-id="870bb-220">**ID**</span><span class="sxs-lookup"><span data-stu-id="870bb-220">**Identity**</span></span>|<span data-ttu-id="870bb-221">**nvarchar(** 128 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-221">**nvarchar(** 128 **)**</span></span>|<span data-ttu-id="870bb-222">데이터 형식이 ID로 선언되는 열의 이름입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-222">Column name whose data type is declared as identity.</span></span>|  
    |<span data-ttu-id="870bb-223">**초기값**</span><span class="sxs-lookup"><span data-stu-id="870bb-223">**Seed**</span></span>|<span data-ttu-id="870bb-224">**numeric**</span><span class="sxs-lookup"><span data-stu-id="870bb-224">**numeric**</span></span>|<span data-ttu-id="870bb-225">ID 열의 시작 값입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-225">Starting value for the identity column.</span></span>|  
    |<span data-ttu-id="870bb-226">**ID 증가값**</span><span class="sxs-lookup"><span data-stu-id="870bb-226">**Increment**</span></span>|<span data-ttu-id="870bb-227">**numeric**</span><span class="sxs-lookup"><span data-stu-id="870bb-227">**numeric**</span></span>|<span data-ttu-id="870bb-228">해당 열의 값에 대해 사용하는 증가값입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-228">Increment to use for values in this column.</span></span>|  
    |<span data-ttu-id="870bb-229">**복제용 아님**</span><span class="sxs-lookup"><span data-stu-id="870bb-229">**Not For Replication**</span></span>|<span data-ttu-id="870bb-230">**int**</span><span class="sxs-lookup"><span data-stu-id="870bb-230">**int**</span></span>|<span data-ttu-id="870bb-231">IDENTITY 속성에는 복제 로그인, 적용 되지 않습니다와 같은 **sqlrepl**, 테이블로 데이터를 삽입 합니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-231">IDENTITY property is not enforced when a replication login, such as **sqlrepl**, inserts data into the table:</span></span><br /><br /> <span data-ttu-id="870bb-232">1 = True</span><span class="sxs-lookup"><span data-stu-id="870bb-232">1 = True</span></span><br /><br /> <span data-ttu-id="870bb-233">0 = False</span><span class="sxs-lookup"><span data-stu-id="870bb-233">0 = False</span></span>|  

-   <span data-ttu-id="870bb-234">열에 대해 반환된 추가 결과 집합입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-234">Additional result set returned on columns:</span></span>  

    |<span data-ttu-id="870bb-235">열 이름</span><span class="sxs-lookup"><span data-stu-id="870bb-235">Column name</span></span>|<span data-ttu-id="870bb-236">데이터 형식</span><span class="sxs-lookup"><span data-stu-id="870bb-236">Data type</span></span>|<span data-ttu-id="870bb-237">설명</span><span class="sxs-lookup"><span data-stu-id="870bb-237">Description</span></span>|  
    |-----------------|---------------|-----------------|  
    |<span data-ttu-id="870bb-238">**RowGuidCol**</span><span class="sxs-lookup"><span data-stu-id="870bb-238">**RowGuidCol**</span></span>|<span data-ttu-id="870bb-239">**sysname**</span><span class="sxs-lookup"><span data-stu-id="870bb-239">**sysname**</span></span>|<span data-ttu-id="870bb-240">GUID(Globally Unique Identifier) 열의 이름입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-240">Name of the global unique identifier column.</span></span>|  

-   <span data-ttu-id="870bb-241">파일 그룹에 대해 반환되는 추가 결과 집합입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-241">Additional result set returned on filegroups:</span></span>  

    |<span data-ttu-id="870bb-242">열 이름</span><span class="sxs-lookup"><span data-stu-id="870bb-242">Column name</span></span>|<span data-ttu-id="870bb-243">데이터 형식</span><span class="sxs-lookup"><span data-stu-id="870bb-243">Data type</span></span>|<span data-ttu-id="870bb-244">설명</span><span class="sxs-lookup"><span data-stu-id="870bb-244">Description</span></span>|  
    |-----------------|---------------|-----------------|  
    |<span data-ttu-id="870bb-245">**Data_located_on_filegroup**</span><span class="sxs-lookup"><span data-stu-id="870bb-245">**Data_located_on_filegroup**</span></span>|<span data-ttu-id="870bb-246">**nvarchar(** 128 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-246">**nvarchar(** 128 **)**</span></span>|<span data-ttu-id="870bb-247">데이터의 위치를 가리키는 파일 그룹: 기본, 보조 또는 트랜잭션 로그입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-247">Filegroup in which the data is located: Primary, Secondary, or Transaction Log.</span></span>|  

-   <span data-ttu-id="870bb-248">인덱스에 대해 반환되는 추가 결과 집합입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-248">Additional result set returned on indexes:</span></span>  

    |<span data-ttu-id="870bb-249">열 이름</span><span class="sxs-lookup"><span data-stu-id="870bb-249">Column name</span></span>|<span data-ttu-id="870bb-250">데이터 형식</span><span class="sxs-lookup"><span data-stu-id="870bb-250">Data type</span></span>|<span data-ttu-id="870bb-251">설명</span><span class="sxs-lookup"><span data-stu-id="870bb-251">Description</span></span>|  
    |-----------------|---------------|-----------------|  
    |<span data-ttu-id="870bb-252">**index_name**</span><span class="sxs-lookup"><span data-stu-id="870bb-252">**index_name**</span></span>|<span data-ttu-id="870bb-253">**sysname**</span><span class="sxs-lookup"><span data-stu-id="870bb-253">**sysname**</span></span>|<span data-ttu-id="870bb-254">인덱스 이름입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-254">Index name.</span></span>|  
    |<span data-ttu-id="870bb-255">**Index_description**</span><span class="sxs-lookup"><span data-stu-id="870bb-255">**Index_description**</span></span>|<span data-ttu-id="870bb-256">**varchar(** 210 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-256">**varchar(** 210 **)**</span></span>|<span data-ttu-id="870bb-257">인덱스에 대한 설명입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-257">Description of the index.</span></span>|  
    |<span data-ttu-id="870bb-258">**index_keys**</span><span class="sxs-lookup"><span data-stu-id="870bb-258">**index_keys**</span></span>|<span data-ttu-id="870bb-259">**nvarchar(** 2078 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-259">**nvarchar(** 2078 **)**</span></span>|<span data-ttu-id="870bb-260">인덱스가 작성된 열의 이름입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-260">Column names on which the index is built.</span></span> <span data-ttu-id="870bb-261">xVelocity 메모리 최적화 columnstore 인덱스에 대해서는 NULL을 반환합니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-261">Returns NULL for xVelocity memory optimized columnstore indexes.</span></span>|  

-   <span data-ttu-id="870bb-262">제약 조건에 대해 반환되는 추가 결과 집합입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-262">Additional result set returned on constraints:</span></span>  

    |<span data-ttu-id="870bb-263">열 이름</span><span class="sxs-lookup"><span data-stu-id="870bb-263">Column name</span></span>|<span data-ttu-id="870bb-264">데이터 형식</span><span class="sxs-lookup"><span data-stu-id="870bb-264">Data type</span></span>|<span data-ttu-id="870bb-265">설명</span><span class="sxs-lookup"><span data-stu-id="870bb-265">Description</span></span>|  
    |-----------------|---------------|-----------------|  
    |<span data-ttu-id="870bb-266">**constraint_type**</span><span class="sxs-lookup"><span data-stu-id="870bb-266">**constraint_type**</span></span>|<span data-ttu-id="870bb-267">**nvarchar(** 146 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-267">**nvarchar(** 146 **)**</span></span>|<span data-ttu-id="870bb-268">제약 조건의 유형입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-268">Type of constraint.</span></span>|  
    |<span data-ttu-id="870bb-269">**constraint_name**</span><span class="sxs-lookup"><span data-stu-id="870bb-269">**constraint_name**</span></span>|<span data-ttu-id="870bb-270">**nvarchar(** 128 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-270">**nvarchar(** 128 **)**</span></span>|<span data-ttu-id="870bb-271">제약 조건의 이름입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-271">Name of the constraint.</span></span>|  
    |<span data-ttu-id="870bb-272">**delete_action**</span><span class="sxs-lookup"><span data-stu-id="870bb-272">**delete_action**</span></span>|<span data-ttu-id="870bb-273">**nvarchar(** 9 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-273">**nvarchar(** 9 **)**</span></span>|<span data-ttu-id="870bb-274">삭제 작업 인지 여부를 나타냅니다. NO_ACTION, CASCADE, SET_NULL, 인지 나타냅니다, 또는 해당 없음.</span><span class="sxs-lookup"><span data-stu-id="870bb-274">Indicates whether the DELETE action is: NO_ACTION, CASCADE, SET_NULL, SET_DEFAULT, or N/A.</span></span><br /><br /> <span data-ttu-id="870bb-275">FOREIGN KEY 제약 조건에만 적용됩니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-275">Only applicable to FOREIGN KEY constraints.</span></span>|  
    |<span data-ttu-id="870bb-276">**update_action**</span><span class="sxs-lookup"><span data-stu-id="870bb-276">**update_action**</span></span>|<span data-ttu-id="870bb-277">**nvarchar(** 9 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-277">**nvarchar(** 9 **)**</span></span>|<span data-ttu-id="870bb-278">업데이트 작업 인지 여부를 나타냅니다. NO_ACTION, CASCADE, SET_NULL, 인지 나타냅니다, 또는 해당 없음.</span><span class="sxs-lookup"><span data-stu-id="870bb-278">Indicates whether the UPDATE action is: NO_ACTION, CASCADE, SET_NULL, SET_DEFAULT, or N/A.</span></span><br /><br /> <span data-ttu-id="870bb-279">FOREIGN KEY 제약 조건에만 적용됩니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-279">Only applicable to FOREIGN KEY constraints.</span></span>|  
    |<span data-ttu-id="870bb-280">**status_enabled**</span><span class="sxs-lookup"><span data-stu-id="870bb-280">**status_enabled**</span></span>|<span data-ttu-id="870bb-281">**varchar(** 8 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-281">**varchar(** 8 **)**</span></span>|<span data-ttu-id="870bb-282">제약 조건이 사용 되는지 여부를 나타냅니다. Enabled, 사용 안 함, 또는 해당 없음.</span><span class="sxs-lookup"><span data-stu-id="870bb-282">Indicates whether the constraint is enabled: Enabled, Disabled, or N/A.</span></span><br /><br /> <span data-ttu-id="870bb-283">CHECK 및 FOREIGN KEY 제약 조건에만 적용됩니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-283">Only applicable to CHECK and FOREIGN KEY constraints.</span></span>|  
    |<span data-ttu-id="870bb-284">**status_for_replication**</span><span class="sxs-lookup"><span data-stu-id="870bb-284">**status_for_replication**</span></span>|<span data-ttu-id="870bb-285">**varchar(** 19 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-285">**varchar(** 19 **)**</span></span>|<span data-ttu-id="870bb-286">복제에 제약 조건을 적용할지 여부를 나타냅니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-286">Indicates whether the constraint is for replication.</span></span><br /><br /> <span data-ttu-id="870bb-287">CHECK 및 FOREIGN KEY 제약 조건에만 적용됩니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-287">Only applicable to CHECK and FOREIGN KEY constraints.</span></span>|  
    |<span data-ttu-id="870bb-288">**constraint_keys**</span><span class="sxs-lookup"><span data-stu-id="870bb-288">**constraint_keys**</span></span>|<span data-ttu-id="870bb-289">**nvarchar(** 2078 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-289">**nvarchar(** 2078 **)**</span></span>|<span data-ttu-id="870bb-290">제약 조건을 구성하는 열의 이름이거나, 기본값 및 규칙의 경우에는 기본값 또는 규칙을 정의하는 텍스트입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-290">Names of the columns that make up the constraint or, in the case for defaults and rules, the text that defines the default or rule.</span></span>|  

-   <span data-ttu-id="870bb-291">참조하는 개체에 대해 반환되는 추가 결과 집합입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-291">Additional result set returned on referencing objects:</span></span>  

    |<span data-ttu-id="870bb-292">열 이름</span><span class="sxs-lookup"><span data-stu-id="870bb-292">Column name</span></span>|<span data-ttu-id="870bb-293">데이터 형식</span><span class="sxs-lookup"><span data-stu-id="870bb-293">Data type</span></span>|<span data-ttu-id="870bb-294">설명</span><span class="sxs-lookup"><span data-stu-id="870bb-294">Description</span></span>|  
    |-----------------|---------------|-----------------|  
    |<span data-ttu-id="870bb-295">**테이블에서 참조**</span><span class="sxs-lookup"><span data-stu-id="870bb-295">**Table is referenced by**</span></span>|<span data-ttu-id="870bb-296">**nvarchar(** 516 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-296">**nvarchar(** 516 **)**</span></span>|<span data-ttu-id="870bb-297">테이블을 참조하는 다른 데이터베이스 개체를 식별합니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-297">Identifies other database objects that reference the table.</span></span>|  

-   <span data-ttu-id="870bb-298">저장 프로시저, 함수 또는 확장 저장 프로시저에 대해 반환되는 추가 결과 집합입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-298">Additional result set returned on stored procedures, functions, or extended stored procedures.</span></span>  

    |<span data-ttu-id="870bb-299">열 이름</span><span class="sxs-lookup"><span data-stu-id="870bb-299">Column name</span></span>|<span data-ttu-id="870bb-300">데이터 형식</span><span class="sxs-lookup"><span data-stu-id="870bb-300">Data type</span></span>|<span data-ttu-id="870bb-301">설명</span><span class="sxs-lookup"><span data-stu-id="870bb-301">Description</span></span>|  
    |-----------------|---------------|-----------------|  
    |<span data-ttu-id="870bb-302">**Parameter_name**</span><span class="sxs-lookup"><span data-stu-id="870bb-302">**Parameter_name**</span></span>|<span data-ttu-id="870bb-303">**nvarchar(** 128 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-303">**nvarchar(** 128 **)**</span></span>|<span data-ttu-id="870bb-304">저장 프로시저 매개 변수의 이름입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-304">Stored procedure parameter name.</span></span>|  
    |<span data-ttu-id="870bb-305">**형식**</span><span class="sxs-lookup"><span data-stu-id="870bb-305">**Type**</span></span>|<span data-ttu-id="870bb-306">**nvarchar(** 128 **)**</span><span class="sxs-lookup"><span data-stu-id="870bb-306">**nvarchar(** 128 **)**</span></span>|<span data-ttu-id="870bb-307">저장 프로시저 매개 변수의 데이터 형식입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-307">Data type of the stored procedure parameter.</span></span>|  
    |<span data-ttu-id="870bb-308">**길이**</span><span class="sxs-lookup"><span data-stu-id="870bb-308">**Length**</span></span>|<span data-ttu-id="870bb-309">**smallint**</span><span class="sxs-lookup"><span data-stu-id="870bb-309">**smallint**</span></span>|<span data-ttu-id="870bb-310">물리적 스토리지의 최대 길이(바이트)입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-310">Maximum physical storage length, in bytes.</span></span>|  
    |<span data-ttu-id="870bb-311">**prec**</span><span class="sxs-lookup"><span data-stu-id="870bb-311">**Prec**</span></span>|<span data-ttu-id="870bb-312">**int**</span><span class="sxs-lookup"><span data-stu-id="870bb-312">**int**</span></span>|<span data-ttu-id="870bb-313">전체 자릿수 또는 총 자릿수입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-313">Precision or total number of digits.</span></span>|  
    |<span data-ttu-id="870bb-314">**소수 자릿수**</span><span class="sxs-lookup"><span data-stu-id="870bb-314">**Scale**</span></span>|<span data-ttu-id="870bb-315">**int**</span><span class="sxs-lookup"><span data-stu-id="870bb-315">**int**</span></span>|<span data-ttu-id="870bb-316">소수점 오른쪽 자릿수입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-316">Number of digits to the right of the decimal point.</span></span>|  
    |<span data-ttu-id="870bb-317">**Param_order**</span><span class="sxs-lookup"><span data-stu-id="870bb-317">**Param_order**</span></span>|<span data-ttu-id="870bb-318">**smallint**</span><span class="sxs-lookup"><span data-stu-id="870bb-318">**smallint**</span></span>|<span data-ttu-id="870bb-319">매개 변수의 순서입니다.</span><span class="sxs-lookup"><span data-stu-id="870bb-319">Order of the parameter.</span></span>|  

설명Remarks

합니다 sp_help 프로시저에서 현재 데이터베이스 에서만 개체를 찾습니다.The sp_help procedure looks for an object in the current database only.

이름을 지정 하지 않으면 sp_help 개체 이름, 소유자 및 현재 데이터베이스의 모든 개체에 대 한 개체 형식입니다.When name is not specified, sp_help lists object names, owners, and object types for all objects in the current database. sp_helptrigger 트리거에 대 한 정보를 제공 합니다.sp_helptrigger provides information about triggers.

sp_help 는 정렬 가능한 인덱스 열만 표시 되므로, XML 인덱스 또는 공간 인덱스에 대 한 정보를 표시 하지 않습니다.sp_help exposes only orderable index columns; therefore, it does not expose information about XML indexes or spatial indexes.

사용 권한Permissions

public 역할의 멤버 자격이 필요합니다.Requires membership in the public role. 사용자는 하나 이상의 권한이 있어야 objname합니다.The user must have at least one permission on objname. 열 제약 조건 키, 기본값 또는 규칙을 보려면 테이블에 대한 VIEW DEFINITION 권한이 있어야 합니다.To view column constraint keys, defaults, or rules, you must have VIEW DEFINITION permission on the table.

Examples

A.A. 모든 개체에 대한 정보 반환Returning information about all objects

다음 예에서는 master 데이터베이스의 각 개체에 대한 정보를 나열합니다.The following example lists information about each object in the master database.

USE master;  
GO  
EXEC sp_help;  
GO  

2.B. 단일 개체에 대한 정보 반환Returning information about a single object

다음 예에서는 Person 테이블에 대한 정보를 표시합니다.The following example displays information about the Person table.

USE AdventureWorks2012;  
GO  
EXEC sp_help 'Person.Person';  
GO  

관련 항목See Also

데이터베이스 엔진 저장 프로시저 (TRANSACT-SQL) Database Engine Stored Procedures (Transact-SQL)
sp_helpindex (TRANSACT-SQL) sp_helpindex (Transact-SQL)
sp_helprotect(Transact-SQL) sp_helprotect (Transact-SQL)
sp_helpserver(Transact-SQL) sp_helpserver (Transact-SQL)
sp_helptrigger(Transact-SQL) sp_helptrigger (Transact-SQL)
sp_helpuser (TRANSACT-SQL) sp_helpuser (Transact-SQL)
시스템 저장 프로시저(Transact-SQL) System Stored Procedures (Transact-SQL)
sys.sysobjects (TRANSACT-SQL)sys.sysobjects (Transact-SQL)