There is a DESCRIBE statement in SQL Server, but I assume you're more after the MySQL DESCRIBE statement. Like Mike suggested, use sp_help.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

Well, no. I avoid triggers if there is any other option. In this case, I...

quote:

---

but if one wants just the ID to be a foreign key then one must abandon DRI and instead write triggers or...

Didn't you say above you've tried to rename and it didn't work ?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Have you searched through the book section on this site?

You might find something valuable.

For DTS you might want to take a look at http://www.sqldts.com .

There is also a site called...

Well, if noone knows another solution....

Frank

http://www.insidesql.de

http://www.familienzirkus.de

What about exporting all other data into a new table, drop the existing table and rename the new to old?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Not sure if I understand.

Are you searching for the table sysmessages in master?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Nice one, tried it but not even in EM I am able to drop this column.

Curious on the solution, though!

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Why, David?

Datetime data types help us solving many problems we wouldn't have without them.

I remember back in the 'good old dbase days' everybody I knew had...

Sorry, lost somehow track of the thread, but to be honest I have no idea...

Frank

http://www.insidesql.de

http://www.familienzirkus.de

uhoh...don't wanted to complicate this

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I think you must execute this dynamically. So something like this should work

DECLARE @stmt nvarchar(100) --Additional declaration

Replace your ALTER TABLE statement with this