prakasham
prakasham
prakasham
prakasham
prakasham selamban wrote:I have put it this query when i run this query in query analyzer
"alter table students alter column student bigint nocheck constraint all"
it throws error like Incorrect syntax near the keyword 'nocheck'.
prakasham
prakasham selamban wrote:helo friend
Disable Constraints
exec sp_MSforeachtable ‘ALTER TABLE ? NOCHECK CONSTRAINT ALL
Enable Constraints
exec sp_MSforeachtable ‘ALTER TABLE ? CHECK CONSTRAINT ALL
this stored procedure enable and disable constraints in sql.
but only its used to delete or insert the records. This is not used to alter data type in sql. Is there any other query to disable or enable constraint. let me know
prakasham
prakasham
OCUP UML fundamental and ITIL foundation
prakasham
alter table id student column ID bigint
OCUP UML fundamental and ITIL foundation
prakasham
prakasham
prakasham
[OCP 21 book] | [OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Won't you please? Please won't you be my neighbor? - Fred Rogers. Tiny ad:
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
|