Thursday, December 04, 2003

Patrick Steele Says -

Find all SQL Identity columns.

I had a need today to find all columns in a SQL database that were identity columns (across all tables). Thanks to SQL's system tables, it was a breeze:

 select o.name + '.' + c.name from syscolumns c, sysobjects o where c.status & 128 = 128 and o.id = c.id order by o.name
[WebLogs @ ASP.NET]
9:51:24 AM    trackback []     Articulate [] 


© Copyright 2003 Dewayne Mikkelson .
Last update: 12/31/2003; 12:22:06 PM .

Click here to visit the Radio UserLand website. Valid CSS! Subscribe to "Dewayne Mikkelson and his Radio WebDog, Shadow" in Radio UserLand. Click to see the XML version of this web page. Click here to send an email to the editor of this weblog.