Question about Microsoft SQL Server Standard Edition for PC

1 Answer

To delete a column from a table working /as sysdba

Hi.
can u tell me that if i'm workin under sysdba',how cn i delete a column from a table.
if i use "set unused" funda,its showing an error tht you can't delete a column from sysdba.
reply soon

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Microsoft Master
  • 2,794 Answers

If your password is setup for admin, you should be able to bring up the table structure and delete the field. You may need to disable SQL server to do this if your table is opened on another computer.

Posted on Nov 17, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

My Y table got deleted. When I click 2nd graph I see the x table but the next column is empty I need my Y column.


You need to define a function before you get anything in the ytable. The x-value are there by default.

Sep 05, 2015 | Office Equipment & Supplies

Tip

Deleting Rows & Columns from the table


You can also remove columns or rows from the table. Once a row or column is deleted, it can be undeleted by using Undo command. You can delete the columns or rows or cells by using one of the following ways.
By Table Menu
To delete a row or column by Table menu, follow these steps.
  • Place the insertion point in the column or row that is to be deleted.
  • Click Table menu and then select "Delete" from Table menu, a submenu of Delete is displayed.
  • Select Columns or Rows or Cells command to delete the selected element (column or row or cell) from the table.
By Popup Menu
To delete a row or column by popup menu, follow these steps.
  • Select the column's you want to delete.
  • Right click the mouse, a popup menu is displayed.
  • Select "Delete Columns" command, the selected columns will be deleted.
OR
  • Place the insertion point in the column or row that is to be deleted.
  • Right click the mouse, a popup menu is displayed.
  • Select "Delete Cells" command, "Delete Cells" dialog box is appeared.
  • Select "Delete entire row" to delete a row or select "Delete entire column" to delete a column etc. from the dialog box and click "Ok" button.

on Jan 29, 2010 | Computers & Internet

2 Answers

How to make a 7 row and a 7 coloum in a spreadsheet


Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
  • Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

  • Click on the "Insert" tab at the top of the document.

  • Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

  • Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

  • Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

  • Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

  • Thanks for choosing Fixya............ Sandeep

    Mar 18, 2011 | Computers & Internet

    1 Answer

    I want to enter in numbers for L1 and L2, but when I go the TABLE there is no L1 or L2 column, only X, and there are numbers entered in the X column that I want to delete. How do I clear the X values,...


    The table is where the calculator displays values from functions entered in the Y= page. To enter numbers into lists, press STAT and select Edit to get into the list editor.

    Dec 21, 2010 | Texas Instruments TI-84 Plus Calculator

    1 Answer

    The car wont come out of park


    The problem is with the shift interlock switch...the device which prevents the transmission from being shifted out of park without the brake pedal pressed. The switch is usually located somewhere under dash near steering column on column shift models and under the console on floor shift models. Have it replaced.

    Jun 11, 2010 | 1995 Oldsmobile Eighty Eight

    1 Answer

    I accidentally deleted they y column from my


    If that Y-Column was created by a function (Y1=...) recreate the table by pressing [2nd][GRAPH] (TABLE).
    If the column is a list of statistical data that you entered, there is no way to restore it. Just reenter the data anew.

    Jan 28, 2010 | Texas Instruments TI-83 Plus Calculator

    1 Answer

    Deleted y column in TABLE


    I do not think that you can DELETE it, you probably just cleared the equation, just put another equation into Y=, and it will work.

    otherwise, if you don't have any programs you need or so... just press 2nd +

    Scroll down to reset, and press clear RAM

    May 26, 2009 | Texas Instruments TI-84 Plus Silver...

    1 Answer

    All lights not workin


    check the turn signal switch... purchase one then plug it in under the steering column first then check them...if all lights work, change the switch out..if not , take back and tell them it was not installed and you dont need it

    May 13, 2009 | 2000 Ford F350 Super Duty Super Cab

    1 Answer

    Hi, I'm workin in Excel 2003 and I have column A that it has names (they could be repetitif names). Column B that it has dates (it could be repetitif dates but not for the same names in column A) and in...


    I'm certain that I can solve your problem...

    Can you send me a xls file with you data to my e-mail (pfjota@gmail.com) so that I can try with real data ?

    Send these explanation with your email to !

    Thanks

    May 01, 2009 | Computers & Internet

    1 Answer

    My ipod is nt workin


    Start with these five simple solutions: Reset, retry, restart, reinstall, or restore

    http://www.apple.com/support/ipod.five_rs/

    If you need more assistance let me know. Good luck.

    Mar 28, 2008 | Apple iPod shuffle MP3 Player

    Not finding what you are looking for?
    Microsoft SQL Server Standard Edition for PC Logo

    Related Topics:

    60 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    micky dee

    Level 3 Expert

    2644 Answers

    Piyal Perera
    Piyal Perera

    Level 3 Expert

    528 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18384 Answers

    Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides

    Loading...