|
USE myDB
GO
---- Drop Table if it already exists
IF OBJECT_ID('dbo.sample_table', 'U') IS NOT NULL
DROP TABLE dbo.myTable
GO
---- Create Table
CREATE TABLE dbo.myTable
(
ID int NOT NULL,
Name char(23) NULL,
DOB datetime NULL,
CONSTRAINT PK_myTable PRIMARY KEY (ID)
)
GO
|