Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DataType Change Expand / Collapse
Author
Message
Posted Wednesday, May 8, 2013 12:00 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 17, 2013 12:28 AM
Points: 76, Visits: 28
I'm working on some real time project. There is an already existing DataBase. In that DB, i need to change particular column DataType. Can we change datatype of column without deleting constraints or data?
Is that possible? if there is any,Please help me to resolve the issue.

Thanks in advance :)

--Vizz
Post #1450412
Posted Wednesday, May 8, 2013 12:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:31 AM
Points: 5,162, Visits: 12,010
visu.cts2012 (5/8/2013)
I'm working on some real time project. There is an already existing DataBase. In that DB, i need to change particular column DataType. Can we change datatype of column without deleting constraints or data?
Is that possible? if there is any,Please help me to resolve the issue.

Thanks in advance :)

--Vizz


What do you want to change it from/to?

Can you post the DDL for the table?

Why did you post this in the SSIS forum? How is SSIS involved?



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1450423
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse