Results 1 to 2 of 2

Thread: IsRowGuid

  1. #1
    Join Date
    Sep 2003
    Posts
    3

    Arrow Unanswered: IsRowGuid

    Dear Experts

    How to find out whether the IsRowGuid flag is set for a particular column or not?
    I tried the system tables like syscolumns, sysconstraints etc., I also tried the INFORMATION_SCHEMA view, but to no avail.

    Can anybody help me out.

    Thanks

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Look out for COLUMNPROPERTY in The Holy Book (SQL Server Books Online).

    COLUMNPROPERTY
    Returns information about a column or procedure parameter.

    Syntax
    COLUMNPROPERTY ( id , column , property )

    Arguments
    id

    Is an expression containing the identifier (ID) of the table or procedure.

    column

    Is an expression containing the name of the column or parameter.

    property

    Is an expression containing the information to be returned for id, and can be any of these values.

    Property : IsRowGuidCol
    The column has the uniqueidentifier data type and is defined with the ROWGUIDCOL property.

    Value Returned
    1 = TRUE
    0 = FALSE
    NULL = Invalid input
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •