answersLogoWhite
Computer Programming
Database Programming
Periodic Table

How you can delete a column from the table?


Top Answer
User Avatar
Wiki User
Answered 2006-12-24 20:49:06

Can you be more specific? What kind of table do you mean, and what program are you using? A SQL statement like this will do it: alter table tblName drop column colName tblName is the name of the table colName is the name of the column

001
๐Ÿ™
0
๐Ÿคจ
0
๐Ÿ˜ฎ
0
๐Ÿ˜‚
0
User Avatar

Your Answer

Loading...

Still Have Questions?

Related Questions

Shortcut command used to delete a table column?

Delete column


To delete a field in a table right-click the column heading for the field and then click on the shortcut menu?

I believe it is "Delete Column"


IN ACCESS How DO YOU delete a column from the table?

Go to the Design View for the table. Then click on the field name for the column you want to get rid of and press the delete key. It will prompt you to make sure you want to do it, as you will lose the data in it if you do. Click OK if you want to and it will be gone. When you next open the table, the column will no longer be in it.


What are the parts of a basic SQL query?

The basic parts of a SQL Select query are: SELECT column names FROM table name WHERE conditions ORDER BY column names The basic parts of an insert query would be: INSERT INTO table name (VALUES) The basic parts of a delete query would be DELETE FROM table name WHERE conditions The basic parts of an update query would be UPDATE TABLE table name SET column name = value WHERE conditions


How do you delete a column in a spreadsheet?

It depends on if you want to delete only the contents of the column or remove the entire column from the worksheet. If you want to remove the entire column, right-click on the column heading and click on the delete menu option. If you want to leave the column, and delete only the contents, right-click on the column heading and press the Delete key.


Delete column vba excel?

to delete column B Columns("B:B").Delete Shift:=xlToLeft


How do you delete rows and columns from am Microsoft Excel table?

Left mouse click on the cell at the start of the row or column and drag the mouse down or across (as required ) to highlight all the cells you want to delete then go to Edit. then Delete. You will get a small window asking if you wish to move the shift cells up, cells down or delete row or column. Alternatively select the top of a column to be deleted, select Delete column from the Edit function. similarly for a row, select the row and use the delete function in the edit area. Details of where the column and row delete functions are will vary depending on which version of Excel you are using.


How to delete columns and rows in Excel in 2003?

Click on the row or column header to select the row or column. Go to the Edit menu and select Delete.Click on the row or column header to select the row or column. Go to the Edit menu and select Delete.Click on the row or column header to select the row or column. Go to the Edit menu and select Delete.Click on the row or column header to select the row or column. Go to the Edit menu and select Delete.Click on the row or column header to select the row or column. Go to the Edit menu and select Delete.Click on the row or column header to select the row or column. Go to the Edit menu and select Delete.Click on the row or column header to select the row or column. Go to the Edit menu and select Delete.Click on the row or column header to select the row or column. Go to the Edit menu and select Delete.Click on the row or column header to select the row or column. Go to the Edit menu and select Delete.Click on the row or column header to select the row or column. Go to the Edit menu and select Delete.Click on the row or column header to select the row or column. Go to the Edit menu and select Delete.


How do you delete a row or column from your worksheet?

Click on the row or column header you want to delete. Then right click and pick Delete.


What is the shortcut command used to delete a column?

There is no keyboard shortcut key to delete a column, nor is there any special command. The quickest way to delete the contents of a column is to click on the letter at the top of the column you want to delete and press the Del key.


What is the easiest way to delete a row or column?

The easiest way to delete a row or column is to select it by clicking the row or column header and pressing Delete. This removes all the data in the row or column, leaving it blank.


What is the difference between a column constraint and a table constraint?

column constraint is for a single column. table constraint is for an entire table.


How do you declare foreign key in db2?

-- two dashes mean a comment in DB2 for VM and z/OS -- 1st design your table - considered optional -- 2nd declare your table - maditory. You still can not alter a table that -- does not exist -- 3rd alter the table to add the foreign key -- DB2 for FOREIGN KEY ALTER TABLE owner.Tablename ADD CONSTRAINT name FOREIGN KEY (column name(s) ) REFERENCES REDBA.RESF_FINAL_CARD (column name(s) ) ON DELETE RESTRICT -- means stop them or ON DELETE cascade -- Cascade means to delete everthing here or ON DELETE SET value -- update the value of the column ; -- note since you are doing DDL not dml the commit is implicit!! so -- there is no COMMIT WORK needed


To add a column to the right of the last column of an existing Word table select table then?

to add a column to the right of the last column of an existing Word table select table then A. insert Columns to the Right B. insert Column C. insert Cells Column Right D. insert column 1


What is a column or family on the periodic table called?

a column or family on the periodic table


How do you drop a column?

If by "drop a column," you mean how do you delete a column, here is the answer for Excel 2007:Look on the Home tab in the Cells section.Click on the drop-down menu for Delete.Click Delete Sheet Columns.


What is a leftmost column?

It is the first column in a table on the left. In a spreadsheet it would be column A. In Access it would the column for the first field. In a table in Word, it would be the first column on the left.


What does a Database management system contain?

A DBMS contains a set of Schemas, tables and views that are used to stored/organize user information logically. The user has options to view, insert, update and delete the data present in the tables.DBMS Schema 1 Table 1 Column 1Column 2Column 3...Table 2Table 3...Schema 2Schema 3...


A column on the periodic table is called?

A column on the periodic table is called a group. There are a total of 18 groups in a periodic table.


In what column is beryllium in?

Beryllium is in column 2 of a wide form periodic table and column II(A) of a narrow form periodic table.


How do you delete pivot table in excel?

Select the entire table and press the Delete key.


What are the components of relational database?

Table, index, trigger and column Table, index, trigger and column


What is a column known as?

In a periodic table a column is a group.


If you delete query does it delete the original information in the table?

Your question is unclear. If you mean if you delete a query, then it does not affect the data in the table. Deleting any kind of query does not affect the data in any table it uses. If you mean if you run a Delete query, then yes the data in the table will be deleted. That is what Delete queries are for.


What direction is a column in the periodic table?

A column, also called group, is a vertical line on the periodic table.