Hi,<BR>Is there a way I can do the "drop table tablename cascade constraints" in SQLserver 2k, as in Oracle.<BR>If anyone has used ERwin, pls answer this, I am really really stuck up.<BR>I am creating a script using erwin and when ever I change some tables, I need to drop only those tables and need to recreate them, but the problem is it doesnt drop because it has references to foreign keys. But oracle does the same using the above command.<BR>Any help in this regard is appreciated.<BR><BR>Thanx in anticipation<BR><BR>U corsa<BR>