Prüfen welche/ob Tabelle ein AutoIncrement/Identiy Spalte hat
| ID | 65 |
|---|---|
| Link Reference | Not set |
| Link Credits | Not set |
| Link Technical Documentation | Not set |
| PlCodelang | T-SQL |
| PlGroup | Datenbank |
| PlItemTitle | Prüfen welche/ob Tabelle ein AutoIncrement/Identiy Spalte hat |
| Code | -- Welche Tabellen ... select o.name, c.name, from sys.objects o inner join sys.columns c on o.object_id = c.object_id where c.is_identity = 1 -- -------------------------------------- -- Hat diese Tabelle ... IF ((SELECT OBJECTPROPERTY( OBJECT_ID(N'dbo.myTable'), 'TableHasIdentity')) = 1) PRINT 'Yes' ELSE PRINT 'No' |
| Result Example |