34,837
社区成员




USE tempdb
GO
IF OBJECT_ID('t') IS NOT NULL
DROP TABLE t
GO
CREATE TABLE t(
id INT,
n NVARCHAR(10)
)
GO
SELECT COLUMN_NAME,ORDINAL_POSITION FROM information_schema.columns WHERE TABLE_NAME='t'
/*
COLUMN_NAME ORDINAL_POSITION
id 1
n 2
*/
GO
ALTER TABLE t ADD n2 INT
GO
SELECT COLUMN_NAME,ORDINAL_POSITION FROM information_schema.columns WHERE TABLE_NAME='t'
/*
COLUMN_NAME ORDINAL_POSITION
id 1
n 2
n2 3
*/