SqlServer 获取标识列的方法
时间:2022-03-14 04:25
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.columns WHERE TABLE_NAME=‘tablaname‘ AND COLUMNPROPERTY(OBJECT_ID(‘tablaname‘),COLUMN_NAME,‘IsIdentity‘)=1
时间:2022-03-14 04:25
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.columns WHERE TABLE_NAME=‘tablaname‘ AND COLUMNPROPERTY(OBJECT_ID(‘tablaname‘),COLUMN_NAME,‘IsIdentity‘)=1