473,396 Members | 1,724 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

How to delete a unwanted university field from my instructor table?

Expand|Select|Wrap|Line Numbers
  1. DELETE FROM INSTRUCTOR TABLE WHERE UNIVERSITY TABLE='INSTRUCTOR';
This syntax produces the statement "0 rows deleted"?

what am i doing wrong?
Dec 21 '10 #1
4 1168
gpl
152 100+
What exactly are you trying to achieve? Deleting data from a table or removing a column (field) from the structure ?
Dec 21 '10 #2
I'm trying to remove a column from the structure!Sorry my description was a bit lame!I'm kind of struggling with the syntax of SQL!
Dec 21 '10 #3
Rabbit
12,516 Expert Mod 8TB
If you're trying to alter the structure of the table then you need to use an ALTER TABLE DROP COLUMN command.
Dec 21 '10 #4
Thanks Rabbit that worked in the end!Have a good Christmas!
Dec 23 '10 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Marco Simone | last post by:
Hi, What is your opinion about using Lookup field in table. I would like to use lookup field in table 1, so that I can choose data in combo box from table 2. Is this good design of database? ...
5
by: jamie | last post by:
Hi, I have a table with 1 million rows that I need to delete. Is there a way to delete them quickly considering I get errors if I try to select them all and then hit delete? What I'm...
3
by: jeff | last post by:
Dear all, i want to delete all records in a table (ms access database) now my method used is not good, i have to loop all record in the datatable and delete it one by one. however, i can't :
4
by: Bonzol | last post by:
..Net 2003, 1.1, Access database. oledb connection Hey there, I had my program updating to the database with a dataset,,, doing things the easy way, binding the dataset to the text box n such,...
4
by: Akinyemi | last post by:
I am currently using Visual Basic 6 to write a Payroll Program. I created a Database with one Table in Microsoft Access that ships with Office 2000. The name of the Database is "Payroll", and the...
4
by: bdockery | last post by:
Access 2007 I have a table with three columns. Country, State, City What I want to do is have a form where the Country, and State, lookups auto-populate when the city lookup is chosen. It...
1
by: ssq | last post by:
Hi, Can someone help me how to write a code on a Delete Command Button. I want to delete all the records of table 'A' once i click on that Delete Command Button, please help me with full code....
4
by: sijugeo | last post by:
Hi I am new to sql server. I have a table named employees which have a primary key emp_id. this table is related to another table department whose forign key is emp_id. Now I need to delete a...
3
by: blakerrr | last post by:
Hi All, I have a strange situation that I can't figure out. The task is quite simple, delete a record from a table. Here is my situation: I have a form called Order Create which cycles through...
1
by: sd_eds | last post by:
I have two fields, "Item" and "Information" in the same table. "Information" contains three items from a seperate table created by a lookup. I would like to substring out the first item and place...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.