Page 1 of 1

TCRSQLConnection.GetTableNames return some system tables

Posted: Sat 07 Oct 2006 07:14
by ccy
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?

Posted: Mon 09 Oct 2006 11:53
by Jackson
This is MS SQL Server behaviour.
There is no way to get to know if the view is system or not.