Monday, 12 January 2015

DROP TABLE AND CREATE TABLE IN MSSQLSERVER 2012

DROP TABLE TEMP_POINT_MAST

CREATE TABLE TEMP_POINT_MAST(
C_ID NVARCHAR(MAX),
USER_NAME NVARCHAR(100) PRIMARY KEY,
SP_ID NVARCHAR(MAX),
SP_NAME NVARCHAR(MAX),
SPILL_ID NVARCHAR(MAX),
SPILL_NAME NVARCHAR(MAX),
POSITION NVARCHAR(MAX),
TAG NVARCHAR(10)

)

No comments:

Post a Comment