в 13:46, 26 мая 2010

2010-05-26T13:46:06Z

Admin: 1 версия

2010-05-26T10:19:55Z

1 версия

Новая страница

==A statement that qualifies the table to be deleted==



<source lang="sql">

DROP TABLE New_AP.dbo.Bankers1
</source>

==Drop a table if necessary==



<source lang="sql">

1>
2> CREATE TABLE department(dept_no CHAR(4) NOT NULL,
3> dept_name CHAR(25) NOT NULL,
4> location CHAR(30) NULL)
5> GO
1>
2> insert into department values ("d1", "developer", "Dallas")
3> insert into department values ("d2", "tester", "Seattle")
4> insert into department values ("d3", "marketing", "Dallas")
5> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
1>
2> select * from department
3> GO
dept_no dept_name location
------- ------------------------- ------------------------------
d1 developer Dallas
d2 tester Seattle
d3 marketing Dallas
(3 rows affected)
1>
2> drop table department
3> GO
1>

</source>

==If table exists, rename and create new one==



<source lang="sql">

12>
13> IF EXISTS(SELECT name FROM sys.tables
14> WHERE name = "T")
15> BEGIN
16> PRINT "T already."
17> DROP TABLE T_old
18> EXEC sp_rename "T", "T_old"
19> END
20> ELSE PRINT "No T already."
21>
22> CREATE TABLE T (
23> c1 bigint,
24> c2 nvarchar(max)
25> )
26>
27> drop table t
28> GO
No T already.
1>

</source>

← Предыдущая	Версия 13:46, 26 мая 2010
(нет различий)

SQL Server/T-SQL/Table/Drop Table - История изменений

в 13:46, 26 мая 2010

Admin: 1 версия