In query analyzer run exec sp_help TABLE_NAME
To get information about a tables columns, datatypes etc. >From: "Mike Kear" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: SQL <[EMAIL PROTECTED]> >Subject: RE: Does EM Expire? >Date: Tue, 21 May 2002 11:19:40 +1000 > >Thanks Jeffry. > >The issue with Query Analyser is that it's quick and reliable with many >things, but there's no SQL command that I've found that will give you the >structure of a table. What I often need is to see all the fields in a >table and their definitions. This you can see in the SQL to create the >table. But Query Analyser can't give you that. ( Can it?) And tinkering >with indexes and such like is near impossible using SQL but a cinch with >EM. >And not having EM has made life tricky indeed for all my hosted databases. > >Yes, my hosting partner could give me the EM. He's in Washington DC and >I'm >in Sydney Australia. So as you imply, I've got the right to have a copy, >because I'm paying for the client licenses through my hosting fees, but >getting the host to cut a CD with it and mail it to me is not a simple >task. > >Thanks for your help. I'll go ahead and load the EM off this eval disk and >if you're wrong, I guess I'll find out in August. <g> > >Cheers, >Mike Kear >Windsor, NSW, Australia >AFP WebWorks > > >-----Original Message----- >From: Jeffry Houser [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, May 21, 2002 11:12 AM >To: SQL >Subject: Re: Does EM Expire? > >At 10:39 AM 5/21/2002 +1000, you wrote: > >Does the Enterprise Manager on the 120day eval Version of MS >SQLServer2000 > >expire too? > > No... > At least not in my experience. > You should be able to load Enterprise Manager and Query Analyzer without >problems. The evaluation server will stop working. > Theoretically your hosting partner should be able to provide you with a >copy of Enterprise Manager. I have never met one that would, though. > > >All I want to do is get full access to my > >databases on SQL2000 and MSAccess doesn't do it, and doing a lot of >things > >by SQL commands through the Query Analyser is clumsy and time-consuming. > > What are alternatives to Query Analyzer? > It is functional for what I need it to do, but not the easiest / user >friendly product in the world. > > >-- >Jeffry Houser | mailto:[EMAIL PROTECTED] >Need a Web Developer? Contact me! >AIM: Reboog711 | Fax / Phone: 860-223-7946 >-- >My Books: http://www.instantcoldfusion.com >My Band: http://www.farcryfly.com > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
