SQL Enterprise Manager Tip

Tuesday, December 14, 2004 3:06 PM Filed under:

General

SQL/Data

SQL Enterprise Manager Tip

I'm in the same boat as Scott Mitchell on this one. I practically live inside of SQL Enterprise Manager. Been using it for years abd years. But I never knew about this. You can go to the table listing and CTRL+C then go to a text editor and CTRL+V to paste the selected table's CREATE TABLE statement. No need to go through the Generate SQL Scripts menu option, just copy away. It works with multiple tables selected too, and also with views, procs, etc.

Comments

Ted 12/15/2004 4:44 PM

Just posted this on the SLX Newsgroups because I was so darn excited to find this new trick ... no need for it today, but will definately keep this in my "bag of tricks".

Ted
Peini 2/18/2005 1:26 PM

I was looking for other tips, but found this, it's cool although I'm still new for the enterprise manager.
Rogelio 3/31/2005 12:01 PM

That's fine this tip..very useful..
hashim 1/6/2006 2:02 AM

E-R
Steven 4/1/2006 7:02 AM

After all these years.... and I just didn't know. Very cool feature.

Thanks
Prasanna 5/29/2006 4:24 PM

very very very coollll ... thanks....