<p>I want to do this in code, not with ALT+F1.</p>

```
```
sp_help tablename
```
```
In the output look for something like this:
```
```
Identity     Seed     Increment     Not For Replication    
 -----------  -------  ------------  ---------------------- 
 userid       15500    1             0
```
```