General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I need to clarify this post:
1) I am working with a FREE TABLE. I want to add an index tag using alter table.
2) I am not sure this accomplishes what I want - I want to just create a tag. I don't need to set up a relationship betwen tables.
3)I see an example in the help that says:
ALTER TABLE orders;
ADD FOREIGN KEY cust_id TAG cust_id REFERENCES customer
I guess the references clause is required, and sets up a relationship between the two tables? When I add the references clause - I get the error that non-dbc tables are not supported.
>Instead of opening my table inventory, and then executing:
>
>index on kit tag kit
>
>I want to execute:
>
>alter table inventory add foreign key kit tag xkit
>
>When I execute this I get a syntax error. Does this not work as it should or am I misunderstanding something about the syntax of this command?
>
>TIA
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only