At 04:35 PM 2/9/2005, you wrote:
>Nick Baker wrote:
> >
> > Error Occurred While Processing Request
> > Error Executing Database Query.
> > [Macromedia][SQLServer JDBC Driver][SQLServer]The object
> > 'DF__HartGrap__Horiz__123EB7A3' is dependent on column 'HorizMark'.
>
>You probably have an index or foreign key on the field that you
>need to drop first.
>
>Jochem
Jochem,
I don't see anything like that. At least that I understand, as I am new to
SQL. Below is the code that originally created the table. I am able to
change HorizMark from "NOT NULL" to "NULL". That is no big deal except
suggests to me the rest of the query appears valid.
CREATE TABLE HartGraph (
IDNumb int NOT NULL default 0,
HorizMark int NOT NULL default 0,
)
CREATE INDEX HartGraphIDX
ON HartGraph (IDNumb)
Executing the following
SELECT * FROM INFORMATION_SCHEMA.TABLES
Resulted in the following
Ordinal Position: 2
Column Name: HorizMark
Data Type: int
Column Default: (0)
Maximum Length
Datetime Precison
Table Catalog: Loyalguard
Table Name: HartGraph
Table Schema: dbo
How would I recognize a foreign key?
Thanks,
Nick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193987
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
