|
4> IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id('Shippers')
5> AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
6> DROP TABLE Shippers
7> GO
1>
2> CREATE TABLE Shippers(
3> ShipperID int IDENTITY (1, 1) NOT NULL,
4> CompanyName nvarchar (40) NOT NULL,
5> Phone nvarchar (24) NULL
6> )
7> GO
1>
2> drop table Shippers;
3> GO
|