TCRSQLConnection.GetTableNames return some system tables

ccy · Post by **ccy** » Sat 07 Oct 2006 07:14

Hi,

I am using MSSQL 2000. I use TCRSQLConnection.GetTableNames to return a list of user tables. However, it return 3 extra tables that isn't not created by me:

1. dtproperties
2. sysconstraints
3. syssegments

This is my code:
var S: TStringList;
begin
S := TStringList.Create;
SQLConnection1.GetTableNames(S, False);
S.Free;
end;

Any ideas?

Jackson · Post by **Jackson** » Mon 09 Oct 2006 11:53

This is MS SQL Server behaviour.
There is no way to get to know if the view is system or not.