maandag, april 24, 2006

 

information schema sqlserver

More a personal reminder post. Once in a while you need to query the database information schema. Here the query's you can use

http://www.sqlservercentral.com/columnists/bkelley/informationschemaviews.asp

http://msdn2.microsoft.com/en-us/library/ms174123.aspx

http://www.sqlteam.com/default.asp

How to reset the identity field in mssql server:

DBCC CHECKIDENT (, RESEED, 0)


Comments: Een reactie posten

Links to this post:

Een link maken



<< Home