ALTER a Colmn data length

D

Dave

I am running an asp \ sql and trying to modify a text column

mySQL="ALTER TABLE TSSEmplID MODIFY (Note Text(200))"

In place of TEXT, I have tried VARCHAR with the same results.

I am getting a syntax error : Syntax error in ALTER TABLE statement

I am not sure this can be done.

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access VBA question 0
ALTER statement for a table w/ a space in the name??? 1
Alter Table + Add Column w/ variable field name 4
Alter Table Query to Change Accept Zero Length Property ? 1
modifiy field type by vba 6
ALTER COLUMN syntax 2
Using DDL to alter fieldsize 1
Alter Table/Column to RTF 6

Top