Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Ambsgirl
  • Content: Threads
  • Order by date
  1. Ambsgirl

    List Constraints For A Column

    How do I list all the constriants that exist on one column? sp_helpconstraint will list all constraints for the table as does select * from sysobjects where objectproperty(id,N'IsConstraint')=1 and parent_obj=coalesce(object_id('di_menus'),'-1'). I'm trying to delete a column programmatically...
  2. Ambsgirl

    Convert From Varchar to Uniqueidentifier in Update Table Statement

    I need to alter a varchar column to be a uniqueidentifier in code so I've created a temporary column that is a uniqueidentifier and need to copy the values from the old column to my temporary column. Only this generates an error that it cannot convert a varchar into a uniqueidentifier...
  3. Ambsgirl

    Identifying a Constraint vs. Index using the SqlDmo Object

    I have a program that tries to alter various columns which means of course, I have to drop indexes and/or constraints on that column. I was looping through the indexes on the table and doing it that way but many of those indexes in that collection are constraints and I was getting an error...
  4. Ambsgirl

    Alter Column to be an Identity

    I'm trying to programmatically alter a column as an identity. I can change it successfully through Enterprise Manager so I'd imagine there must be a way to actually write a script to do it, isn't there? This does not work: ALTER TABLE DI_BATCHES alter column DB_BATCH_ID int IDENTITY (1, 1)...

Part and Inventory Search

Back
Top