• State Suggested Answer
  • Locked Locked
  • Replies 2 replies
  • Answers 2 answers
  • Subscribers 96 subscribers
  • Views 4198 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Increase Length of a Custom Column

somee.gupta
over 6 years ago

Hi All ,

How can I increase the length of a Custom Column of PersonwantsOrg/ ShoppingCartItem table ? Is there any Stored Procedure for this Which can be used  ( Identity Manager Version - 7.0.1 )

Thanks in Advance.

Parents
  • 0 over 6 years ago

    Hi,

    If this is indeed a 'custom' column ..... then a migration will leave it as is ..... so you can adjust it simply by using a standard SQL 'ALTER' statement. e.g.

    ALTER TABLE [table_name] ALTER COLUMN [column_name] [DataType]([Length])

    HTH, Barry.

Reply
  • 0 over 6 years ago

    Hi,

    If this is indeed a 'custom' column ..... then a migration will leave it as is ..... so you can adjust it simply by using a standard SQL 'ALTER' statement. e.g.

    ALTER TABLE [table_name] ALTER COLUMN [column_name] [DataType]([Length])

    HTH, Barry.

Children
No Data