⑴ 刪除一個表的sql 語句怎麼寫啊
使用drop語句，droptable （需要刪除表的名字）。
drop是刪除整個表，delete是刪除表的內容。
drop語句的作用：刪除內容和定義，釋放空間，簡單來說就是把整個表去掉。以後要新增數據是不可能的，除非新增一個表。
刪除表時需要注意的事項：
1、如果刪除應用表別名，則delete 後面一定要接對應的別名，然後再接表名，不然報錯。
2、delete刪除sql後面不可接通配符*，即delete * from ，這樣會報錯。
3、delete刪除sql默認的返回值為int數據類型，當刪除一條數據時，返回int數據1，當刪除num條數據時，則返回int類型num。
(1)刪除sql語句擴展閱讀：
SQL即結構化查詢語言(Structured Query Language)，是一種特殊目的的編程語言，是一種資料庫查詢和程序設計語言，用於存取數據以及查詢、更新和管理關系資料庫系統；同時也是資料庫腳本文件的擴展名。
SQL語句無論是種類還是數量都是繁多的，很多語句也是經常要用到的，SQL查詢語句就是一個典型的例子，無論是高級查詢還是低級查詢，SQL查詢語句的需求是最頻繁的。
常用語句：
創建資料庫 CREATE DATABASE database-name
刪除資料庫 drop database dbname
創建新表 create table tabname(col1 type1 [not null] [primary key],col2 type2 [not null],..)
刪除新表 drop table tabname
參考資料：網路—sql語句大全
⑵ mysql 刪除sql語句
只能先刪外表，後刪主表
delete
from
s_text
where
pid=5;
delete
from
test
where
id=5;
分步執行吧
資料庫就是怕這樣亂刪，會導致錯誤才弄的外鍵，所以麻煩點就麻煩點吧
⑶ SQL語句如何刪除列
方法和詳細的操作步驟如下：
1、第一步，打開資料庫管理平台軟體[SQL Server Management Studio]，見下圖，轉到下面的步驟。
⑷ SQL刪除語句
首先將shee1和persinfo2個表合並到一起，這里用視圖來實現：
create view A as
（
select sheet1.用戶id ，sheet1.名稱，sheet1.日期，persinfo.cardid ，persinfo.phycardid from sheet1 ， persinfo
where sheet1.用戶id=persifo.用戶id
）
利用視圖刪除
delete from basedata ， A where A.phycardid =basedata.chrphycardid and Convert(varchar(10),a.日期,120)=Convert(varchar(10),basedatadatadate,120)
⑸ 關於刪除的sql語句如何做
對，一般最好把SQL語句寫在一個STRING里，要養成好習慣。
⑹ SQL清除語句
CREATE SNAPSHOT [schema.]snapshot
[ [PCTFREE integer] [PCTUSED integer]
[INITRANS integer] [MAXTRANS integer]
[TABLESPACE tablespace]
[STORAGE storage_clause]
[ USING INDEX [ PCTFREE integer | TABLESPACE tablespace
| INITTRANS integer | MAXTRANS integer
| STORAGE storage_clause ] ...
| [CLUSTER cluster (column [, column]...)] ]
[ REFRESH [FAST | COMPLETE | FORCE] [START WITH date] [NEXT date]]
AS subquery
schema
is the schema to contain the snapshot. If you omit schema, Oracle
creates the snapshot in your schema.
snapshot
is the name of the snapshot to be created.
Oracle chooses names for the table, views, and index used to
maintain the snapshot by prefixing the snapshot name. To limit
these names to 30 bytes and allow them to contain the entire
snapshot name, Oracle Corporation recommends that you limit your
snapshot names to 23 bytes.
PCTFREE
PCTUSED
INITRANS
MAXTRANS
establishes values for these parameters for the internal table
Oracle uses to maintain the snapshot's data.
TABLESPACE
specifies the tablespace in which the snapshot is to be created. If
you omit this option, Oracle creates the snapshot in the default
tablespace of the owner of the snapshot's schema.
STORAGE
establishes storage characteristics for the table Oracle uses to
maintain the snapshot's data.
USING INDEX
specifies the storage characteristics for the index on a simple
snapshot. If the USING INDEX clause not specified, the index is
create with the same tablespace and storage parameters as the
snapshot.
CLUSTER
creates the snapshot as part of the specified cluster. Since a
clustered snapshot uses the cluster's space allocation, do not use
the PCTFREE, PCTUSED, INITRANS, or MAXTRANS parameters, the
TABLESPACE option, or the STORAGE clause in conjunction with the
CLUSTER option.
REFRESH
specifies how and when Oracle automatically refreshes the snapshot:
FAST
specifies a fast refresh, or a refresh using only the
updated data stored in the snapshot log associated
with the master table.
COMPLETE
specifies a complete refresh, or a refresh that re-
executes the snapshot's query.
FORCE
specifies a fast refresh if one is possible or
complete refresh if a fast refresh is not possible.
Oracle decides whether a fast refresh is possible at
refresh time.
If you omit the FAST, COMPLETE, and FORCE options,
Oracle uses FORCE by default.
START WITH
specifies a date expression for the first automatic
refresh time.
NEXT
specifies a date expression for calculating the
interval between automatic refreshes.
Both the START WITH and NEXT values must evaluate to a time in the
future. If you omit the START WITH value, Oracle determines the
first automatic refresh time by evaluating the NEXT expression when
you create the snapshot. If you specify a START WITH value but omit
the NEXT value, Oracle refreshes the snapshot only once. If you
omit both the START WITH and NEXT values or if you omit the REFRESH
clause entirely, Oracle does not automatically refresh the snapshot.
AS subquery
specifies the snapshot query. When you create the snapshot, Oracle
executes this query and places the results in the snapshot. The
select list can contain up to 253 expressions. A snapshot query is
subject to the same restrictions as a view query.
PREREQUISITES:
To create a snapshot in your own schema, you must have CREATE
SNAPSHOT system privilege. To create a snapshot in another user's
schema, you must have CREATE ANY SNAPSHOT system privilege.
Before a snapshot can be created, the user SYS must run the SQL
script DBMSSNAP.SQL on both the database to contain the snapshot and
the database(s) containing the tables and views of the snapshot's
query. This script creates the package SNAPSHOT which contains both
public and private stored proceres used for refreshing the
snapshot and purging the snapshot log. The exact name and location
of this script may vary depending on your operating system.
When you create a snapshot, Oracle creates a table, two views, and
an index in the schema of the snapshot. Oracle uses these objects
to maintain the snapshot's data. You must have the privileges
necessary to create these objects. For information on these
privileges, see the CREATE TABLE, CREATE VIEW, and CREATE INDEX
commands.
The owner of the schema containing the snapshot must have either
space quota on the tablespace to contain the snapshot or UNLIMITED
TABLESPACE system privilege. Also, both you (the creator) and the
owner must also have the privileges necessary to issue the
snapshot's query.
To create a snapshot, you must be using Oracle with the proceral
option. To create a snapshot on a remote table or view, you must
also be using the distributed option.
⑺ sql刪除語句
delete後面最多允許一個欄位,而且出現一個欄位的情況是表裡面只有一個欄位.
所以這個語句沒有
⑻ sql語句刪除數據
如果是 <NULL> 用update
刪除是刪除單條或多條記錄不是修改值，樓主視乎還不是很理解sql語句的用法
⑼ 刪除資料庫的sql語句如何寫
1、drop database：資料庫名--刪除資料庫的。
2、drop table：表名--刪除表的。
3、delete from：表名--where條件--刪除數據的。
4、truncate table：表名--也是刪除資料庫的。
拓展資料
1、SQL即結構化查詢語言(Structured Query Language)，是一種特殊目的的編程語言，是一種資料庫查詢和程序設計語言，用於存取數據以及查詢、更新和管理關系資料庫系統；同時也是資料庫腳本文件的擴展名。
2、SQL語句無論是種類還是數量都是繁多的，很多語句也是經常要用到的，SQL查詢語句就是一個典型的例子，無論是高級查詢還是低級查詢，SQL查詢語句的需求是最頻繁的。
⑽ SQL刪除語句（有條件的）
delete from URTAB where id not in (select parentid from URTAB)
這樣會把所有末梢部門全部宰了，這里末梢部門指所有沒有子部門的單位——
不管它有沒有父部門
如果需要保留沒有父部門的，加上一個條件
delete from URTAB where parentid not null and id no in (select parentid from URTAB)