Dot Net Sample Codings
Tuesday, August 23, 2016
Add new Column in Existing Table
IF
NOT
EXISTS
(
SELECT
*
FROM
INFORMATION_SCHEMA
.
COLUMNS
WHERE
TABLE_NAME
=
'tblName'
AND
COLUMN_NAME
=
'ColumnName'
)
BEGIN
ALTER
TABLE
tblName
ADD
ColumnName
nvarchar
(
60
)
END
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment